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 > > > > > ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
