OK, I've done a little digging and this works in CFMX 6 and 7:
<CFQUERY NAME="demoq" DATASOURCE="cfdocexamples">
select * from employees
where lastname = <cfqueryparam value="smith"
cfsqltype="CF_SQL_VARCHAR">
</CFQUERY>
<cfdump var="#demoq#">
<cfset factory = createobject("java", "coldfusion.server.ServiceFactory")>
<cfset debug = factory.DebuggingService.getDebugger().getData()>
<cfquery dbtype="query" name="getqueries">
select * from debug
where template = '#cgi.cf_template_path#' and type='SqlQuery'
</cfquery>
<cfoutput query="getqueries">
Query name: #name#<br>
SQL statement: #body#<br>
<cfdump var="#getqueries.attributes#"><!--- this is an array--->
<p>
</cfoutput>
<!--- <cfdump var="#debug#"> --->
Note that if you wanted to get just one particular query on a page, you
could add a WHERE clause for name='yourqueryname' in the Q of Q.
/Charlie
http://www.carehart.org/blog/
-----Original Message-----
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Scott Thornton
Sent: Tuesday, February 20, 2007 8:08 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Query Parameter List in the Error Structure
Hi Charlie,
Using CF MX 6.1.
Damn.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en
-~----------~----~----~----~------~----~------~--~---
