If you enable CF debugging through the cf administrator site, you'll
be able to view the SQL passed to the DB in the debugging information.
-joe
----- Original Message -----
From: Ubqtous <[EMAIL PROTECTED]>
Date: Mon, 9 Aug 2004 10:32:23 -0400
Subject: Re: dump query before execution
To: CF-Talk <[EMAIL PROTECTED]>
I'd just take a copy of the query code and replace the CFQUERY tags
with CFOUTPUT and then CFABORT afterwards to display the post-CF code
processing SQL.
On Mon, 9 Aug 2004 10:25:27 -0400, George Abraham
<[EMAIL PROTECTED]> wrote:
> 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]
