Not sure it will help but this the SQL to create the tables for MS SQL. Note the table names are CDATA and CGLOBAL (not cFdata and cFglobal):
CREATE TABLE [dbo].[CDATA] ( [cfid] [char] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [app] [char] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [data] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] CREATE TABLE [dbo].[CGLOBAL] ( [cfid] [char] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [data] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [lvisit] [datetime] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] ----- Original Message ----- From: "Jonathan Block" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Monday, March 12, 2007 1:24 AM Subject: Can I use CLIENT variable storage with MySQL 5? I'm trying very hard to figure out how to get MySql 5 to work with CF client variable storage. I need that... its a requirement. Has anybody done it before? The CF administrator does not have it built in, and when I try to manually create CFDATA and CFGLOBAL, my front end app errors out with a "500" database error. Thank you, Jon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272336 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
