One solution would be to always put queries into the request scope...

cfquery name="request.whatever"

Then you could loop over the request scope looking for queries and append 
their names to a list.

<cfset session.querylist = "">
<cfloop collection="#request#" item="thisKey">
     <cfset x = evaluate("request." & thisKey)>
     <cfelseif IsQuery(x)>
         <cfset session.querylist = ListAppend(session.querylist,thisKey)>
     </cfif>
</cfloop>

BTW other scopes (session, client, etc) will work too. So long as CF will 
let you loop over them as a structure. However "Variables" does not work.


At 10:22 AM 9/12/2002 -0500, you wrote:
 > Does any one know how to get the names of all of the queries that have
 > run on a particular page? I want to store them in a structure or a
 > variable. Just like CF displays on debugging output. I asked my local
 > CFUG and didn't get any good answers. So I'll try a (hopefully) wider
 > audience and see if you guys can answer it. Thanks in advance!
 > Dave
 >
 > P.S. I am running CF5.

______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to