>><cfoutput>

        <cfloop collection="#variables#" item="i">
                <cfif isquery(variables[i])>
                        #i#: #variables[i].recordcount# records<br>
                </cfif>
        </cfloop>
</cfoutput>

 >>That code would assume the queries existed in the variables scope and
had been run on that page.

Exact, but even so, it appears that the variable scope itself is not 
available from the error template,
though the form scope is.
By the way, may be the request scope is, so putting all queries in the 
request scope could be a solution.
Having all queries in the session scope is definitely too costly 
performance wise, and using the Application
scope would made the application a one user only application.

 >>The sessiontracker method
in the service factory will give you everyone's sessions, but I don't
know that the performance of recursing that struct would be advisable.

If the queries were defined in the session, I wouldn't have to parse 
everyone's session, only the session
that caused the error, but I don't think putting all queries in session 
variables wouls be wise.

 >>The contents of the
variables scope is destroyed at the end of the page load anyway

Right, but by definition, errors occur before the end of the page load, 
so there is no reason the variable
scope would not be available from the error template defined in CFERROR, 
just like the form scope,
which is also destroyed after page load.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion 8 beta – Build next generation applications today.
Free beta download on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280642
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to