There's a HUGE warning not to distribute that code, so I'd recommend against it. That's why I didn't post it originally. May as well keep the hacking as legit as possible.
barneyb > -----Original Message----- > From: Matthew Walker [mailto:[EMAIL PROTECTED] > Sent: Friday, February 28, 2003 2:12 PM > To: CF-Talk > Subject: Re: Display the used query. > > > 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
