MACROMEDIA COLDFUSION 5-ADVANCED ADMINISTRATION, Руководство пользователя

Страница: 29 / 372

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>