I spent the last hour trying to find an answer to my question with no luck.
I have a custom error page that emails me with alot of info but one thing I
would LOVE is to see the value of the sql params that where sent to the
database.  For now I have this ( parital listing ) in the email:

 

Diagnostics [#error.diagnostics#]:

Error Executing Database Query. Invalid data for CFSQLTYPE CF_SQL_FLOAT. 

The error occurred on line 487.

 

Last SQL Code [#error.rootCause.SQL#]:

UPDATE Invoice SET Paid = (param 1) WHERE Ident = (param 2) 

 

Is there a way to extract the param values and place it in the email also.
Thanks...




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225903
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to