Try dumping the entire error. There is another variable that contains the parameters.
On Thu, Mar 25, 2010 at 10:40 AM, Scott Thornton < scott.thorn...@hnehealth.nsw.gov.au> wrote: > > 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<cfaussie%2bunsubscr...@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<cfaussie%2bunsubscr...@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<cfaussie%2bunsubscr...@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.
