Well, there's a problem with this already. If the query is still active, you wouldn't know how many records had been returned because it wouldn't have returned yet.
Depending on your database, just run a query like what I had suggested. I'm not sure what the commands are in anything other than MS SQL. ~Brad -----Original Message----- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, June 07, 2007 1:58 PM To: CF-Talk Subject: Re: Finding current queries >>Not sure what you mean? Are you trying to get a report of every currently running template which is querying the database at that point in time? Exact, I'd like to list all active queries in my onError template, together with the number of records found. This could help for debugging. -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280415 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
