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:

    
  1. 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:

Bill To - Ship To Information display (1997) Multi-Row Tables from a search. (1997) [SearchString] problem with [search] context (1997) Variable prices and Formulas.db (1997) authorize net (2001) what characters are replaced for tab and CR? (1998) Max Record length restated as maybe bug (1997) carriage returns in data (1997) Doctype (2004) Re2: AAgghh!! Help, please. SSL strikes again. (1997) [copyfile] and symlinks (2004) Specifying the URL where a user should go (2000) Show new (2003) PCS Frames (1997) Searching help needed (1998) Calendar (1997) Price recalc based on quantity (1997) For those of you not on the WebCatalog Beta... (1997) WebCatalog can't find database (1997) unsubscribe (1997)