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
______________________________________________________________________
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
