ColdFusion Muse

2 Comments

Leave this field empty

Write a comment

Remember My Information:

Subscribe:

If you subscribe, any new posts to this thread will be sent to your email address.

Subscribe to Comments

Remember My Information:

• 

  Posted By

  Glenn Dominguez | 9/23/06 1:35 AM

  You can turn on debugging if it's not already enabled with:
  cfdebugger.setEnabled(1)
  
  The only problem here is that it won't work for the current request. Once the page is refreshed, debugging will be enabled. Also, if you want don't want the cf debug output, there is a method to disable it's display. I think it's cfdebugger.showDebug(0) or showDebugging(0), you can find out by cfdumping your cfdebugger var.
• 

  Posted By

  Glenn Dominguez | 9/23/06 1:44 AM

  Sorry, but I forgot to comment on your last paragraph. You actually CAN get each of multiple queries from a page:
  
  <CFQUERY DBTYPE="query" NAME="getquery" DEBUG="false">
  SELECT body
  FROM events
  WHERE type='SqlQuery'
  ORRDER BY timestamp asc
  </CFQUERY>
  <cfset queries = ArrayNew(1)>
  <cfloop query="getquery">
  <cfset queries[currentrow] = body>
  </cfloop>
  
  I use code such as this to capture and store all insert, update and delete queries from my admin app.