How to retreive a Query string..?

[alagukannan]

Hi,
I want to retreive all the queries that were executed in the Page.
I don't want to enable debugging in server..and don't want to store query in a
variable.No use of log files also.

So is there a way to get the query string..Something like getting debug
information ...

Thx
AL

[Kronin555]

Nope, you pretty much said you didn't want to use any of the methods that can possibly do this for you.

[mxstu]

I don't know if this works when debugging disabled, but if you are using MX 7,
you could try using the "results" attribute of cfquery and then accessing the
#result_name.sql# value. See
[url]http://livedocs.macromedia.com/coldfusion/7/htmldocs/00000316.htm[/url] for more
details.

[Kronin555]

mxstu, I didn't know about result.sql, that's pretty neat. Too bad I'm not on MX7... Maybe alagukannan is...

[mxstu]

Yes it does look cool. I haven't used it yet ... and I'm not on MX7 at the moment, but I saw the feature and was practically salivating ;-)

[alagukannan]

Thats Kool,But I don't have a Mx7.
I need the query to generate a csv file.I Can export to excel using IE,but I
have implemented paging..So can't export all the values
There are too many queries and too many files..so i can't go and change
manually.I had planned to do with a custom tag or application.cfm.But i have to
catch the query..anyway ?
Is there any other i can approach this problem..?

thx
AL

[mxstu]

Nevermind. I see Kronin555 just suggested the JDBC route I was thinking of ;-)