> I seem to remember (somewhere) a way of getting the actual SQL of a
> query that has been run in a variable (ie: for debugging, etc).
<cfquery name="q" datasource="dsn">
your query here
</cfquery>
<cfset factory = createObject("java", "coldfusion.server.ServiceFactory")>
<cfset cfdebugger = factory.getDebuggingService()>
<cfset qEvents = cfdebugger.getDebugger().getData()>
<cfquery dbtype="query" name="cfdebug_queries" debug="false">
SELECT *, (endTime - startTime) AS executionTime
FROM qEvents
WHERE type = 'SqlQuery'
</cfquery>
<cfdump var="#cfdebug_queries#">
Pinched from the debugging template @ CFusionDir]\WEB-INF\debug\classic.cfm
Adam
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
