it takes up valuable time slices :)
Doug
----- Original Message -----
From: Christian Watt <[EMAIL PROTECTED]>
Date: Tue, 31 Aug 2004 13:34:52 -0500
Subject: RE: CFQuery
To: CF-Talk <[EMAIL PROTECTED]>
Yes, you are correct, but the requesting IPAddress has to be in the
debugging IP Addresses. otherwise IsDebugMode returns false. This
brings up an interesting question though, if my ip is not in the list
then I don't get debug information and debug mode is turned off, so why
is debugging being enabled on a production machine bad? This is near
the top of my page also. I would also like to know of some way to
return the query as well. And yes, I understand I can rewrite all of
queries as strings, but was really hoping to not do that since most of
them are going to become stored procs pretty soon anyway.
Christian
-----Original Message-----
From: Qasim Rasheed [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 31, 2004 12:11 PM
To: CF-Talk
Subject: Re: CFQuery
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]
