List all query names

[stewartconsulting]

I'm on a server that does not allow me to look at the normal debuging information. Does anyone know how to loop over all the queries and dump the results?

[CFDEBUG]

Ver 7 has a new attribute to cfquery called result. And that has a variable
called sql. So if you use
<cfquery name="" datasource="" result="q1">

<cfoutput>#q1.sql#</cfoutput>

Older versions, why can't you just put the query inside cfoutput instead of
cfquery and that will display all your queries.

[zoeski80]

Hi Randy

You could copy the default debugging output page code and make your own debug
page to include on your pages.
C:\CFusionMX\wwwroot\WEB-INF\debug\classic.cfm

I have done this for all the scope variables, haven't tried it for the Queries
but can't see why it shouldn't work.

HTH

Zoe