cferror and error.diagnostics

[plarts]

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.

[JR__Bob__Dobbs]

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