Here is what I have:
<cfquery name="TableColumns" datasource="#Client.Database#">
explain #form.TableName#
</cfquery>
<cfloop query="TableColumns">
<cfoutput>#Field# - #Type# - #Null#</cfoutput>
</cfloop>
-----Original Message-----
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 20, 2002 5:28 PM
To: CF-Talk
Subject: Re: mysql EXPLAIN [tablename] in CFQUERY?
Does your situtation look something like this? Are you putting the
query="EXPLAIN" in the loop?
<cfquery datasource="xxx" name="EXPLAIN">
SQL Stuff
</cfquery>
<cfloop query="EXPLAIN">
#data#<br>
</cfloop>
Paul Giesenhagen
QuillDesign
> I am trying to return the result set of an EXPLAIN tablename command
from
> a mysql database. I can query the table directly with no problems. The
> EXPLAIN returns a result set from the command line properly. But it seems
> that CFQUERY does not return anything. When I try to loop through the
> result, it gives me an error:
>
>
> The QUERY attribute of the tag does not specify the name of an available
> query
______________________________________________________________________
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
