Skip to main content
Inspiring
September 13, 2010
Question

cferror and error.diagnostics

  • September 13, 2010
  • 1 reply
  • 842 views

I use the CFerror to catch the error by mail and show a nice screen.

I have sometimes an error on a Query (which is with a lot of variables in it)

But in the mail I receive, I use the #error.diagnostics#,

and it does not show me the entire query which has executed at the error.

If I do not use the CFerror , I can see the error, and it gives the full query executed,

which is good to debug.

As this error is in very few times, even if I do it manually, I do not have these errors.

So how to show the full query used in the mail sent by the CFerror ?

Thanks for answer or recommandations.

Pierre.

This topic has been closed for replies.

1 reply

Inspiring
September 13, 2010

You might try adding error.rootCause and/or error.rootCause.sql to the debugging data.

http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7d29.html