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]

