But late, but tou could use SQL Profiler.
"This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: John Skrotzki <[EMAIL PROTECTED]> To: CF-Talk <[email protected]> Sent: Fri Dec 02 05:41:54 2005 Subject: Error SQL Params 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... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225953 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
