<cfsavecontent variable="SQLCommand">
SELECT * FROM TableName WHERE column = #CFVar#
</cfsavecontent>
<cfdump var="#SQLCommand#">
<cfquery name="MyQuery" datasource="dsn">
#SQLCommand#
</cfquery>
________________________________
From: George Abraham [mailto:[EMAIL PROTECTED]
Sent: Monday, August 09, 2004 9:25 AM
To: CF-Talk
Subject: dump query before execution
Hi group,
Does anyone have an idea of how to dump the contents of a query before
it executes? Say I have a query named getThisUser. All I want is the
contents of the select statement before it actually is passed to the
database. I am having a problem with a long query (with lots of cfifs
and cfqueryparams) and I want to see why it is hanging up/timing out
on me. I know I can just remove the cfquery tag and have it output out
on the screen, but I was looking for a more elegant (?) way of doing
it on a consistent basis for other queries as well.
TIA,
George
________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
