Hi,

Does anyone have a solution to the problem of preventing duplicate records when adding records to a separate table?

I would like to display a grid view of products and allow the user to click a button on a row and add that product to a wish list table.
Before the record is inserted I would like to check that the item has not already been inserted.

If anyone has a solution or knows of a decent tutorial I would be very grateful.

Thanks

__________________
Try our latest project www.nobanx.com Currency Exchange for members

Only way to do this is by code. You will have to query (with COUNT()) the table for the fields entered with the WHERE clause checking on each field to see if any rows match what the user inputted. If count is greater than "0" then you have a duplicate entry. Hard part about that is if they word it differently you will still get duplicates just worded differently.

Thanks for your answer.

Another suggestion from someone was


Just do a;

SELECT ProductID FROM WishListTable WHERE ProductID = <selected Product ID>
If you don't get an empty result set back you know the product is already there. Or if you are using SQL Server Stored Procedures;


IF NOT EXISTS (SELECT 1 FROM WishListTable WHERE ProductID = <selected Product ID>)
    INSERT INTO WishListTable
    ...


These set me looking for tutorials and I found one at http://aspalliance.com/687

I've incorporated these suggestions and the tutorial into my system and it works a treat

Thanks again