I am not sure if this solves your problem, but if you have debugging turned
on the server, you can get several information from the servicefactory
debugging object. Here is a UDF that I wrote a while back which return true
if the query ran was a cached one.
http://www.cflib.org/udf.cfm?ID=1202
Th
Yeah, but you'd still have a problem when using s. :o'
Chris
Scott Weikert wrote:
> Well, you could start by throwing the SQL query code into a var to begin
> with:
>
>
>
> Or build it up as you would build it within the tags.
>
> Then execute it:
>
>
> #SQLVar#
>
>
> And since it's already
27;s [query_name].sql.
>
>
> http://www.cfquickdocs.com/?getDoc=cfquery
>
> -Original Message-
> From: Richard Colman [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 22, 2007 1:33 PM
> To: CF-Talk
> Subject: How to dump a sql query to text
>
> I wish to
The only way I've done that before is to do something like:
Select * from blah
Select * from blah
Basically writing the query twice. It kinda sucks, but that's the only
way I've thought of. Also, if your real sql contains cfqueryparams, then
you have to get rid of those in the versi
Well, you could start by throwing the SQL query code into a var to begin
with:
Or build it up as you would build it within the tags.
Then execute it:
#SQLVar#
And since it's already in a var, you can write it to your DB as you see fit.
PM
To: CF-Talk
Subject: How to dump a sql query to text
I wish to store the actual text of a SQL query to a logfile.
At the risk of belaboring the obvious, from:
Select * from blah
I wish to actual put "select * from blah" into a text variable and write it
to a logfile or data tabl
I wish to store the actual text of a SQL query to a logfile.
At the risk of belaboring the obvious, from:
Select * from blah
I wish to actual put "select * from blah" into a text variable and write
it to a logfile or data table.
Can someone suggest an easy way to do this?
TNX.
Rick Colman
7 matches
Mail list logo
