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
>
>
>
>
>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
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
