Avoiding duplicate db entries
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 45109
interpreted = N
texte = Hi there,I was wondering if there was an approved method for avoiding duplicate db entries. We have a site where clients can express their interest in a certain product which is then sent to them free. Naturally the client only wants each person to be able to do this once.Is the only way of avoiding this to search the db through each field before the current form is appended to the database?If you had to compare multiple fields, wouldn't that take a while, especially if the number of records gets to be a lot. Would it be quicker to search in one field, and if a match is found, it then compared the other fields?Any two-cent's worth on this would be apprecaited.Regards, Tim ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
| |
- Avoiding duplicate db entries (Tim Robinson 2002)
|
Hi there,I was wondering if there was an approved method for avoiding duplicate db entries. We have a site where clients can express their interest in a certain product which is then sent to them free. Naturally the client only wants each person to be able to do this once.Is the only way of avoiding this to search the db through each field before the current form is appended to the database?If you had to compare multiple fields, wouldn't that take a while, especially if the number of records gets to be a lot. Would it be quicker to search in one field, and if a match is found, it then compared the other fields?Any two-cent's worth on this would be apprecaited.Regards, Tim ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Tim Robinson
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
off topic