Yup, cfqueryparms can be seen in dumps of sql queries. I guess I was referring to in particular was when an error occurs and the error object is used in displaying error detail. apologies for the confusion.
eg: #error.rootCause.SQL#, #error.rootCause.tagContext[1].SQL# etc. There is no parameters in the above statements. >>> "Steve Onnis" <st...@cfcentral.com.au> 25/03/2010 9:52 am >>> If you use the result argument and dump that you will get the params <cfquery name="bla" result="result".... <cfdump var="#result#" /> -----Original Message----- From: Scott Thornton [mailto:scott.thorn...@hnehealth.nsw.gov.au] Sent: Thursday, 25 March 2010 8:47 AM To: cfaussie@googlegroups.com Subject: [cfaussie] CFqueryparam value's in debug output G'day, Is there any way to access the values for cfqueryparam's in debug output? I am pretty sure I saw a blog entry by someone showing a modification of a file(s) in the coldfusion directory but I cannot find it for the life of me. I'd like to include the query values in a site wide error template and in an email that is sent. Can any recall seeing this too? and point me in the right direction? I thought i saw it at barneyblog or the one by andy jarret but no luck... cf 9 development system, cfmx6.1 in live environment. Scott Thornton, Centralised Billing Unit Hunter-New England Area Health Service ext: 53358 p: +61 02 498 53358 m: 0413 800 242 -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
