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