Hey, great tip! Here's the raw data. It has template requests and queries mixes together, so you use a query of query to split it up.
<cfobject action="CREATE" type="JAVA" class="coldfusion.server.ServiceFactory" name="factory"> <cfset cfdebugger = factory.getDebuggingService()> <cfdump var="#cfdebugger.getDebugger().getData()#"> ----- Original Message ----- From: "Barney Boisvert" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, March 01, 2003 10:36 AM Subject: RE: Display the used query. > If you're on CFMX, the debug output template is not encrypted (at least it > wasn't when I was removing all those damned icons from the list of included > files), so you could go look there and see how they do it. Of course, no > guarentees that it won't change, as it's not a supported feature, but it'd > be a start. > > barneyb > > > -----Original Message----- > > From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] > > Sent: Friday, February 28, 2003 1:36 PM > > To: CF-Talk > > Subject: Re: Display the used query. > > > > > > >> Macromedia Suggestion? > > >> Is there a reason why the content found between the > > >> <cfquery> and > > > </cfquery> tags is not available in a structure variable > > > like > > > query_Name.RecordCount, > > >> query_name.CurrentRow and query_name.ColumnList. > > >> > > >> How is this content provided when I set the DEBUG mode on > > >> in the > > > ColdFusion Administrator Configuration pages? > > > > > It must be in memory there somewhere, right? This would be > > > great for logging > > > changes to a database or slow queries, things like that. > > > > What surprised me was that queryname.executionTime is available (so that > > could be your logging slow queries answer) but that the query > > string wasn't > > also available... I'm sure it eventually will be -- it's just a matter of > > time before MM gets enough requests for it. :) > > > > > > s. isaac dealey 954-776-0046 > > > > new epoch http://www.turnkey.to > > > > lead architect, tapestry cms http://products.turnkey.to > > > > tapestry api is opensource http://www.turnkey.to/tapi > > > > certified advanced coldfusion 5 developer > > http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

