If you are piecing it together into a variable, can't you just use
cfmail to send it to you right before you submit the variable to the
cfquery?

Doug

Ciliotta, Mario wrote:

>Hi,
>
>Is there anyway to get the text of the query that is being executed.  I have a
>page that the query is being pieced together thru the use of dropdowns and so
>on and the problem that I am having is that certain query will return a large
>amount of records (@50,000) and I want to capture every query that is run and
>have it emailed to me so that I can see what the queries are and speak to my
>DBA department to see exactly what has happened to those tables.  
>
>I checked the logs and the page is logged as running longer that the set time
>in tha admin but the page will finally finish.  I know that there is
>#error.querystring#, but is there anyway to get the query string if there is
>no error.
>
>Thanks
>Mario
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to