Chapter 4: Managing Data Sources
121
you need to create the
newtable
data source in the ColdFusion Administrator,
specifying the MERANT dBase/FoxPro ODBC driver. If you don’t create the data source,
you’ll receive an error when you try to execute this page. This example generates the
following tables in the newtable data source.
<HTML>
<HEAD>
<TITLE>DBASE Table Setup</TITLE>
</HEAD>
<BODY>
<!---
Before running this code, you need to create the
newtable
data source in the ColdFusion Administrator,
specifying the Merant dBase/FoxPro ODBC driver.
--->
<CFQUERY NAME=xs DATASOURCE="newtable">
CREATE TABLE Beans1 (
Bean_ID numeric(6),
Name char(50),
Price char(50),
Date date,</P>
Descript char(254))
</CFQUERY>
<CFQUERY NAME=xs DATASOURCE="newtable">
INSERT INTO Beans1 VALUES (
1,</P>
’Kenya’,
’33’,
{ts ’1999-08-01 00:00:00.000000’},
’Round, rich roast’)
</CFQUERY>
<CFQUERY NAME=xs DATASOURCE="newtable">
Fields created in the Beans1 table
Field
Data type
Bean_ID
numeric
Name
char
Price
char
Date
date
Descript
char
Summary of Contents for COLDFUSION 4.5-ADMINISTRING COLDFUSION...
Page 1: ...Allaire Corporation Administering ColdFusion Server ColdFusion 4 5...
Page 10: ...x Administering ColdFusion Server...
Page 22: ...xxii AdministeringColdFusionServer...
Page 48: ...26 Administering ColdFusion Server...
Page 58: ...36 Administering ColdFusion Server...
Page 60: ...38 Administering ColdFusion Server Using ColdFusion in a Distributed Configuration 68...
Page 98: ...76 Administering ColdFusion Server...
Page 150: ...128 Administering ColdFusion Server...
Page 198: ...176 Administering ColdFusion Server...
Page 205: ...Chapter 6 Creating Scalable and Highly Available Web Sites 183 3 Click the DNS tab...
