Re: Can I use CLIENT variable storage with MySQL 5?
Unless things have changed with mySQL you have to hand-create the tables. You'll also have to manually fire up the drivers and dsn as was described earlier. I just went to my server and read out my table stru via SQLYog. Here it is. Note the myISAM table type. Note also the lack of a primary key in the cglobal table. These tables were brought in from a mySQL 4.x installation, and before that they were generated by CF automatically in another platform and then imported into mySQL. CREATE TABLE `cdata` ( `cfid` varchar(64) NOT NULL default '', `app` varchar(64) NOT NULL, `data` longtext NOT NULL, PRIMARY KEY (`cfid`,`app`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 CREATE TABLE `cglobal` ( `cfid` varchar(64) NOT NULL default '', `data` longtext NOT NULL, `lvisit` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, KEY `cfid` (`cfid`,`lvisit`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272608 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Can I use CLIENT variable storage with MySQL 5?
On 3/11/07, Jonathan B wrote: 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. I know it works. I'm not sure what your problem is specifically tho. Doesn't have what built in? The mysql5 driver? You'll need to go and download a newer version from the mysql.com site. I think 3.0.17-ga is the newest that won't slow you down with the varchar strangeness*. Then you can use other when specifying a DSN type, and configure the datasource for mysql 5. *varchar strangeness is the added milliseconds for each varchar field included in the result set. Actually, I think maybe the updated datadirect drivers might have a newer mysql one? If you haven't gotten them from Adobe already, you should. Anyways, I'm not even sure if that's what you're having troubles with. Wanna clarify? Maybe try dropping the table, and running the create script from CF admin again? :-/ ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272333 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can I use CLIENT variable storage with MySQL 5?
With Client variables, I believe you have to first have your datasource set up and working. THEN you go into the CFAdministrator and set up the Client vars. It's a while since i set up Client vars, but if i recall correctly, it has to check the datasource when you 'submit' after changing the details of the client vars. One of hte options at that time is to let it create its own CFDATA and CFGLOBAL tables, and I'd recommend letting it do it. Then you know for sure its all going to work. But i dont believe client vars use any tricky sql at all, so it should work on any database that is avlid datasource for CF. It only does SQLinserts, deletes and selects. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 3/12/07, Dinner [EMAIL PROTECTED] wrote: On 3/11/07, Jonathan B wrote: 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. I know it works. I'm not sure what your problem is specifically tho. Doesn't have what built in? The mysql5 driver? You'll need to go and download a newer version from the mysql.com site. I think 3.0.17-ga is the newest that won't slow you down with the varchar strangeness*. Then you can use other when specifying a DSN type, and configure the datasource for mysql 5. *varchar strangeness is the added milliseconds for each varchar field included in the result set. Actually, I think maybe the updated datadirect drivers might have a newer mysql one? If you haven't gotten them from Adobe already, you should. Anyways, I'm not even sure if that's what you're having troubles with. Wanna clarify? Maybe try dropping the table, and running the create script from CF admin again? :-/ ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272334 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can I use CLIENT variable storage with MySQL 5?
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 cf-talk@houseoffusion.com 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
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 robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272328 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4