> Is there a sample table structure available to be able
> to create a table on MS SQL when moving the client
> variables storage to a database from the registry?
CF creates two table CDATA and CGLOBAL and related indices...
CREATE TABLE CDATA
CFID CHAR (20),
APP CHAR (64),
DATA LONG)
CREATE UNIQUE INDEX ID1 ON
CDATA(CFID, APP)
CREATE TABLE CGLOBAL
CFID CHAR (20),
DATA LONG,
LVISIT DATE)
CREATE INDEX ID2 ON
CGLOBAL(CFID)
CREATE INDEX ID3 ON
CGLOBAL(LVISIT)
I think that's all that was created when I moved the client variables out of
the registry.
Russell Conway
HallofSports.com, Inc.
351 West 22nd Street
New York, NY 10011
P (646) 638-2500
F (561) 423-2674
http://www.hallofsports.com
.. . . where the legends live on
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
