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