<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