Hi there

Can anyone help me with the following (and hopefully easy) problem:

I need to do an online survey - everyone participating in the survey has a unique ID number. People are only allowed to enter the survey once.

I need some code which, before inserting their data into the database, checks the database first for their ID number. If their ID number exists in the database then the data isn't inserted, if it doesn't then the information is added.

Would this be done in a stored procedure, and if so, how?

Thanks in advance

Lucy

IF EXISTS (SELECT * FROM MyTable WHERE IdNumber = 'IdNumberHere')

ELSE
INSERT INTO Statement Here

hi,

a better way is to make the ID column in that survey table "unique". If you do so, you will not be able to insert any row with that ID number..

If you do so, when you try to insert a row with an existing ID, you will get an error (exception).

As i understood, it will be even better if you make that ID column primary key in your table (then, that column will automatically be unique)

hope it helps

I think you should check first if the ID exists in the DB before even trying to run the INSERT. Why have the user enter data only to not be inserted?