They both work from the command line. And changing the query to "describe" generates the same error.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 21, 2002 12:18 PM To: CF-Talk 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#"> > > > And get this: > > Error resolving parameter TABLECOLUMNS > > ColdFusion was unable to determine the value of the parameter. This problem > is very likely due to the fact that either: > > You have misspelled the parameter name, or > You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE > tag. > > The error occurred while processing an element with a general identifier of > (CFDUMP), occupying document position (381:1) to (381:29) in the template > > > Other funny occurence. If I select * from the table in question and loop > through the result I can display the records with no problem. But if I do a > <cfdump> on that queryset, I get a DNS error. > > > -----Original Message----- > From: Ben Forta [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 20, 2002 9:49 PM > To: CF-Talk > Subject: RE: mysql EXPLAIN [tablename] in CFQUERY? > > > Do a <CFDUMP VAR="#explain#"> after the <CFQUERY> to see if anything at > all is returned. > > --- Ben ______________________________________________________________________ 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