Hello, I am wondering if there is a way to differentiate between CF Errors.
Like I have a database that has a unique key setup so it will not allow two records with the same filename field and date field. If you try the insert you get the below CF error. Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Violation of UNIQUE KEY constraint 'IX_CurrentFilesFileNameDate_Unique'. Cannot insert duplicate key in object 'dbo.CurrentFiles'. Now say if the Database is turned off. I will get another error like datasource cannot be found. Is there anyway that in CF I can tell which error is thrown so I can return different data for each error? Right now my code is using <cftry> and <cfcatch>. If the insert is successful then I return a 1. if <cfcatch> finds an error I return a 2. What I want to do is if the unique key is violated I want to return a 1 rather then a 2. Any ideas? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257369 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
