User Guide

122 Administering ColdFusion Server
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>