production systems, eh? try the long hand way
<cfset variables.sql = "select foo from goo" />
<cfquery>
#PreserveSingleQuotes(varaibles.sql)#
</cfquery>
of course you may need to name your sql var different for multiple queries.
Doug
----- Original Message -----
From: Qasim Rasheed <[EMAIL PROTECTED]>
Date: Tue, 31 Aug 2004 13:10:30 -0400
Subject: Re: CFQuery
To: CF-Talk <[EMAIL PROTECTED]>
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]
