I would like to have some error message show at client side from stored procedures.
I use MS SQL Server and use RAISEERROR, but ColdFusion does not bring the error message just ignore the error continue to run the other part of code.
Your help and information is great appreciated,
Just wrap your cfstoredproc in a cftry/cfcatch. See this for an example: