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"

<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'

<cfoutput query="getqueries">
        Query name: #name#<br>
        SQL statement: #body#<br>
        <cfdump var="#getqueries.attributes#"><!--- this is an array--->

<!--- <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.


-----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. 


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 

Reply via email to