March 21, 2002 at 8:22 am
I have a stored procedure that does a simple insert into a table. The procedure is called from Cold Fusion and even though I am trapping errors in the procedure, ODBC displays its own error message immediately and Cold Fusion never receives the error message that I am returning from SQL Server.
How can I stop ODBC from displaying its own error message? Can I stop SQL Server from sending the error message to ODBC or can I trap the ODBC error message in Cold Fusion?
Thanks
Angela
Angela Beckwith
Angela Beckwith
March 21, 2002 at 10:44 am
I think you need to trap it in CF. That's how it's done in VB anyway.
Andy
April 1, 2002 at 1:34 am
It goes pretty much like this:
<cftry>
do your query here
<cfcatch type="database">
give them the message here
</cfcatch>
</cftry>
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply