<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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
