RE: mysql EXPLAIN [tablename] in CFQUERY? (fwd)
cfquery name=getTables datasource=cfmx describe blah /cfquery cfdump var=#getTables# Works for me. Sorry I didn't catch this email sooner and read it, just been busy. ~Todd -- Forwarded message -- Date: Wed, 21 Aug 2002 12:18:05 -0400 (EDT) From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: mysql EXPLAIN [tablename] in CFQUERY? FYI, MySQL doesn't use 'explain table' it uses 'describe table' On Wed, 21 Aug 2002, Lon Lentz wrote: I run this: cfquery name=TableColumns datasource=#Client.Database# explain #form.tablename# /cfquery cfdump var=#TableColumns# -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: mysql EXPLAIN [tablename] in CFQUERY? (fwd)
What OS are you running on? I am running on Linux with Apache/CF 5 using the Merant driver. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 21, 2002 12:25 PM To: CF-Talk Subject: RE: mysql EXPLAIN [tablename] in CFQUERY? (fwd) cfquery name=getTables datasource=cfmx describe blah /cfquery cfdump var=#getTables# Works for me. Sorry I didn't catch this email sooner and read it, just been busy. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: mysql EXPLAIN [tablename] in CFQUERY? (fwd)
I'm using Windows/Apache/MySQL/CFMX and I'm using RH7.2/Apache/MySQL/CFMX. Maybe it's a merant driver problem if it's not a use db problem. ~Todd On Wed, 21 Aug 2002, Lon Lentz wrote: What OS are you running on? I am running on Linux with Apache/CF 5 using the Merant driver. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 21, 2002 12:25 PM To: CF-Talk Subject: RE: mysql EXPLAIN [tablename] in CFQUERY? (fwd) cfquery name=getTables datasource=cfmx describe blah /cfquery cfdump var=#getTables# Works for me. Sorry I didn't catch this email sooner and read it, just been busy. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: mysql EXPLAIN [tablename] in CFQUERY? (fwd)
The use db did not fix it. Are you using a non-Merant driver on your Linux box? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 21, 2002 12:36 PM To: CF-Talk Subject: RE: mysql EXPLAIN [tablename] in CFQUERY? (fwd) I'm using Windows/Apache/MySQL/CFMX and I'm using RH7.2/Apache/MySQL/CFMX. Maybe it's a merant driver problem if it's not a use db problem. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: mysql EXPLAIN [tablename] in CFQUERY? (fwd)
I'm justing whatever drivers came with CFMX, I'm guessing the mysql j drivers or something... or, perhaps it's the jdbc drivers for mysql. ~Todd On Wed, 21 Aug 2002, Lon Lentz wrote: The use db did not fix it. Are you using a non-Merant driver on your Linux box? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 21, 2002 12:36 PM To: CF-Talk Subject: RE: mysql EXPLAIN [tablename] in CFQUERY? (fwd) I'm using Windows/Apache/MySQL/CFMX and I'm using RH7.2/Apache/MySQL/CFMX. Maybe it's a merant driver problem if it's not a use db problem. -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists