On Wed, Aug 26, 2009 at 4:04 PM, Tony Bentley<t...@tonybentley.com> wrote: > > > When this is thrown, the message states "[Macromedia][SQLServer JDBC Driver]" > and then the RAISERROR message following. Nice for debugging but not so nice > for passing the message and error code to a handler. > > I would really like to be able to use the error codes and have a handler > method based on which code it passed back. Not really possible. Kind of hokey > not to throw a SQL exception (and pass back a value instead) since you would > want SQL Server to log the exception.
Have you tried dumping the cfcatch to see what's in there? I find that it often includes much more than the error message you see when not using try/catch... IE, there's a SQLSTATE value in there somewhere and some other stuff. -- Rick Root CFFM - Open Source Coldfusion File Manager http://www.opensourcecf.com/cffm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325753 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4