User Guide

Client Variables 75
<CFQUERY NAME="data2" DATASOURCE="#DSN#">
CREATE UNIQUE INDEX id1
ON CDATA (cfid,app)
</CFQUERY>
<CFQUERY NAME="global1" DATASOURCE="#DSN#">
CREATE TABLE CGLOBAL
(
cfid char(20),
data memo,
lvisit date
)
</CFQUERY>
<CFQUERY NAME="global2" DATASOURCE="#DSN#">
CREATE INDEX id2
ON CGLOBAL (cfid)
</CFQUERY>
<CFQUERY NAME="global2" DATASOURCE="#DSN#">
CREATE INDEX id3
ON CGLOBAL (lvisit)
</CFQUERY>
install.book Page 75 Thursday, May 10, 2001 12:59 PM