Subject | avoiding duplicates |
---|---|
Author | Max Thorne |
Post date | 2005-07-11T12:14:39Z |
Hi,
how can I prevent a user from inserting duplicates in a table? For example I have table "company" with field "name" and a unique index for this field. However, a user can insert values like "Diesel Co.","DIESEL CO.", "diesel co.". Same company, different entries. Thanks!
Max
---------------------------------
Yahoo! Mail for Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
[Non-text portions of this message have been removed]
how can I prevent a user from inserting duplicates in a table? For example I have table "company" with field "name" and a unique index for this field. However, a user can insert values like "Diesel Co.","DIESEL CO.", "diesel co.". Same company, different entries. Thanks!
Max
---------------------------------
Yahoo! Mail for Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
[Non-text portions of this message have been removed]