Using ColdFusion to Create a Data Source (UNIX only)
11
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">
INSERT INTO Beans1 VALUES (
2, ’Sumatra’,
’21’,
{ts ’1999-08-01 00:00:00.000000’},
’Complex flavor, medium-bodied’)
</cfquery>
<cfquery NAME=xs DATASOURCE="newtable">
INSERT INTO Beans1 VALUES (
3, ’Colombia’,
’89’,
{ts ’1999-08-01 00:00:00.000000’},
’Deep rich, high-altitude flavor’)
</cfquery>
<cfquery NAME=xs DATASOURCE="newtable">
INSERT INTO Beans1 VALUES (
4,</P>
’Guatamala’,
’15’,
{ts ’1999-08-01 00:00:00.000000’},
’Organically grown’)
</cfquery>
<cfquery NAME=xs DATASOURCE="newtable">
CREATE UNIQUE INDEX Bean_ID on Beans1 (Bean_ID)
</cfquery>
<cfquery NAME=""QueryTest2"" DATASOURCE="newtable">
SELECT * FROM Beans
</cfquery>
<cfoutput QUERY=""QueryTest2"">
#Bean_ID# #Name#<br>
</cfoutput>
</BODY>
</HTML>
Summary of Contents for COLDFUSION 5-ADVANCED ADMINISTRATION
Page 1: ...Macromedia Incorporated Advanced ColdFusion Administration ColdFusion 5...
Page 20: ......
Page 56: ...38 Chapter 1 Advanced Data Source Management...
Page 74: ...56 Chapter 2 Administrator Tools...
Page 76: ......
Page 86: ...68 Chapter 3 ColdFusion Security...
Page 87: ...To Learn More About Security 69...
Page 88: ...70 Chapter 3 ColdFusion Security...
Page 130: ...112 Chapter 5 Configuring Advanced Security...
Page 132: ......
Page 154: ...136 Chapter 6 Configuring Verity K2 Server...
Page 162: ...144 Chapter 7 Indexing XML Documents...
Page 202: ...184 Chapter 8 Verity Spider...
Page 236: ...218 Chapter 10 Verity Troubleshooting Utilities...
Page 238: ......
Page 348: ...330 Chapter 14 ClusterCATS Utilities...
Page 349: ...Using sniff 331...
Page 350: ...332 Chapter 14 ClusterCATS Utilities...
Page 362: ...344 Chapter 15 Optimizing ClusterCATS...
Page 372: ...354 Index...
