How to check for duplication of records when inserting form contents

[Beng79]

Hello,

I have a ASP script for insertion of form contents into the database.

This is the link to the script that I have posted before in the forum ->

http://www.tek-tips.com/viewthread.cfm?qid=1190366&page=1

Now I need to vadilate whether the data that users have entered have already exist in the database? What SQL statements should I need to add into the script?

Thank you

 

[onpnt]

http://www.w3schools.com/sql/default.asp

Look at the WHERE clause and the LIKE operator




General FAQ faq333-2924
5 steps to asking a question faq333-3811