Err.Number = 0 (?)

[H2]

I have a table that colA is set to be unique.
When I add a duplicate record, this record did not insert, but the err.number is still equal to 0.
any method I can detect this error??

thanks ^^

 

[Tarwn]

Try checking the connection object errors collection:
<%
'if connection object is called conn
Response.Write &quot;There were &quot; & conn.errors.count & &quot; errors returned from the db.<br>&quot;
Dim dberr
For each dberr in conn.errors
Response.Write &quot;Error: &quot; & dberr.number & &quot; - &quot; & dberr.description & &quot;<br>&quot;
Next
%>

Hope this helps,

-Tarwn ________________________________________________________________________________
Want to get great answers to your Tek-Tips questions? Have a look at faq333-2924