Catch database truncate error

[fdgsogc]

Hi,
I want to catch a database truncate error and provide a very specific message that indicates the user is entering too much information. That is, I don't want to just catch the database error generally and say, "You have a database error.". The error code is 8152. Can I catch that specific code and then supply a custom error message.

 

[cfSearching]

It will depend on your current error handling method. But at a basic level, you could use a cftry/cfcatch around the query. Then check error variables like cfcatch.NativeErrorCode or cfcatch.SQLState and use the values to create a more informative error message. IIRC, some of these codes vary by vendor. So keep that in mind if you change database drivers.

http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Errors_17.html

http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Errors_17.html

Having said that, prevention is usually a far more efficient approach. There is no point executing a database query you know will generate an error. Validate the input first and reject any values that exceed your limits. Though you should still have error handling in place for exotic/totally unexpected errors.



----------------------------------

http://cfsearching.blogspot.com/