Re: Can I use CLIENT variable storage with MySQL 5?

2007-03-13 Thread Matt Robertson
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

Re: Can I use CLIENT variable storage with MySQL 5?

2007-03-12 Thread Dinner
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

Re: Can I use CLIENT variable storage with MySQL 5?

2007-03-12 Thread Mike Kear
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

Re: Can I use CLIENT variable storage with MySQL 5?

2007-03-12 Thread Gareth Hughes
) 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

Can I use CLIENT variable storage with MySQL 5?

2007-03-11 Thread Jonathan Block
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