I am using a stored procedure (it does not return a Recordset, all it does is add the 2 variables) to add 2 variables (a name, a zip). A name cannot contain the same zip. If you try to add it, the ODBC driver gives an error back saying no duplicate values to the primary key. I want to capture this error (I tried using the Errors collection, no luck) and then notify the user of the mistake. PLease help.
i'm using sql and doing asp pages.
i've tried your solution, i even tried it yesterday by my own discovery, but keep getting syntax error between goto and InsertError