As far as I can tell after looking at the UDF, it doesn't require an
error to occur before it returns the sql statement. the only
requirement I see is that debugging must be turned on on the server
for this to work. since I am not the author of this udf, I might
completely be wrong
----- Original Message -----
From: Christian Watt <[EMAIL PROTECTED]>
Date: Tue, 31 Aug 2004 12:00:39 -0500
Subject: RE: CFQuery
To: CF-Talk <[EMAIL PROTECTED]>
Reply, not quite, this only works when an error has occurred. I would
like to do this even if an error has not occurred.
<cfquery name="somequery">
Select * from table
</cfquery>
#Output Query Ran#
Christian
-----Original Message-----
From: Qasim Rasheed [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 31, 2004 10:37 AM
To: CF-Talk
Subject: Re: CFQuery
I guess this is what you need
http://cflib.org/udf.cfm?ID=686
----- Original Message -----
From: Christian Watt <[EMAIL PROTECTED]>
Date: Tue, 31 Aug 2004 10:21:43 -0500
Subject: CFQuery
To: CF-Talk <[EMAIL PROTECTED]>
I know you can return the execution time of a query, but how do
you
return what the query ran is? Just like they do when you turn
on
debugging.
Christian________________________________
________________________________________________________________
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
- cfquery Stuart Kidd
- RE: cfquery Philip Arnold
- RE: cfquery Pascal Peters
- RE: cfquery Stuart Kidd
- RE: cfquery Philip Arnold
- RE: cfquery Stuart Kidd
- RE: cfquery Philip Arnold
- CFQuery Christian Watt
- Re: CFQuery Qasim Rasheed
- RE: CFQuery Christian Watt
- Re: CFQuery Qasim Rasheed
- Re: CFQuery Douglas Knudsen
- RE: CFQuery Frank Dewey
- RE: CFQuery Christian Watt
- Re: CFQuery Douglas Knudsen
- RE: CFQuery S . Isaac Dealey
- RE: CFQuery Dave Watts
- Re: CFQuery Adam Haskell
- RE: CFQuery Mark A Kruger
- Re: CFQuery S . Isaac Dealey
- RE: CFQuery Christian Watt