Here's a great CFMX function using the coldfusion.server.ServiceFactory class to get at the
debugging information and extract just the generated SQL for a specific query.
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.
Enter your email address to subscribe to this blog.
Recent Comments
Remembering Wil Genovese
Mary Jo said: Wil's presence here will be sorely missed. We became good friends over the years and I will miss our...
[More]
Remembering Wil Genovese
charlie arehart said: Very sad news, and a real loss for the CF community which was blessed with so much of his knowledge ...
[More]
Remembering Wil Genovese
Mark A Kruger said: @Mike,
Ha - yes! He was always a hoot at staff meetings. :)
To be clear to the rest of the world ...
[More]
Remembering Wil Genovese
Mike Letson said: On several occasions, Will led me through deep technical waters that enabled me to serve my clients ...
[More]
Remembering Wil Genovese
Russ said: Rest in Peace man, my condolences to the family.
Cancer seems to kill so many people now. :-(
Both ...
[More]