The query is built okay. A .recordcount produces the same error. It appears that explain generates a standard queryset in proper form. So I am stumped as to why explain may not be supported.
-----Original Message----- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 5:39 PM To: CF-Talk Subject: Re: mysql EXPLAIN [tablename] in CFQUERY? I don't know if explain is supported .. did you try to output a recordcount? to see if the query is bringing anything in? How about also trying to output your <cfquery statement to see if there are any errors such as: <cfoutput> cfquery name="TableColumns" datasource="#Client.Database#"<br> explain #form.TableName#<br> /cfquery<br> </cfoutput> With the above example, you can make sure that everything is being dynamically populated. Paul Giesenhagen QuillDesign ----- Original Message ----- From: "Lon Lentz" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, August 20, 2002 4:40 PM Subject: RE: mysql EXPLAIN [tablename] in CFQUERY? > 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 ______________________________________________________________________ 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