Insert Record Behavior - Duplicates 1

[Omnillas]

What's the easier approach for handling inserts where a duplicate record may exist? ASP/MSSQL are the language and db in use.

I would like to display a pop-up indicating that a record already exists and list the keys attempted to be inserted.

 

[Kendel]

Something like this:

strSQL = "Select keyname from yourtable where keyname = " & Request.Form("txtKey")

If Not rs.eof then
response.write("record exist")
Else
'insert record
End if