raising custom error's with mssql 2k

[gareth7]

I'm using stored procedures in mssql server to do my database updates.
The stored procedures run various checks and use the RAISERROR statement if something fails

I want CF to be able to tell which error was thrown by the database, so it can act accordingly.
Does anyone know how this would be done?

Thanks

 

[TruthInSatire]

depends on how the error is sent back to cf. if its a single record you can use a simple cfif. if it returns an actual error you can use cferror.

http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p24.htm#wp2022557

We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.

 

[gareth7]

Thanks for the reply.
I'm actually looking for something a bit more detailed

cfcatch.nativeErrorCode is the variable I want to test, but I don't know how I set this with the RAISERROR statement in the stored procedure

 

[TruthInSatire]

ask the mssql forum

We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.