Re: Duplicates

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17764
interpreted = N
texte = >>>Does anyone have a good way for detecting records that have a duplicate >>>value in one field, then noting this, or deleting it? >> >>What's the purpose of this effort? Are you trying to create a keyword field >>that doesn't have duplicate values in it? Or is this for some other purpose >>entirely? > >Sorry, I should have been more specific with my request. >I have a database with 4 fields. ID, Email, adddate, promostatus..To be even more specific, is there *ever* more than one email address in the Email field?Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] prevent database duplicates (Stephen Braun 2019)
  2. Re: [WebDNA] prevent database duplicates (Stuart Tremain 2019)
  3. Re: [WebDNA] prevent database duplicates (Alex Mccombie 2019)
  4. [WebDNA] prevent database duplicates (Stephen Braun 2019)
  5. Re: [WebDNA] [sendmail] random duplicates (Donovan Brooke 2010)
  6. Re: [WebDNA] [sendmail] random duplicates (Steve Raslevich - Northern Sound 2010)
  7. Re: [WebDNA] [sendmail] random duplicates (Tom Duke 2010)
  8. Re: [WebDNA] [sendmail] random duplicates (Stuart Tremain 2010)
  9. Re: [WebDNA] [sendmail] random duplicates (Steve Raslevich - Northern Sound 2010)
  10. Re: [WebDNA] [sendmail] random duplicates (Tom Duke 2010)
  11. [WebDNA] [sendmail] random duplicates (Steve Raslevich - Northern Sound 2010)
  12. Re: Find Duplicates in Cart (John Peacock 2001)
  13. Re: Find Duplicates in Cart (Clint Davis 2001)
  14. Re: Find Duplicates in Cart (John Peacock 2001)
  15. Find Duplicates in Cart (Clint Davis 2001)
  16. How to find duplicates - With code samples (Brian B. Burton 2000)
  17. Re: Deleting duplicates from a db (Matt Helbing 2000)
  18. Re: Deleting duplicates from a db (Michael O Shea 2000)
  19. Deleting duplicates from a db (Will Starck 2000)
  20. Re: WHY SO MANY DUPLICATES? (Martin Bech 1999)
  21. WHY SO MANY DUPLICATES? (The Mooseman 1999)
  22. WHY SO MANY DUPLICATES? (The Mooseman 1999)
  23. Re: Duplicates (Kenneth Grome 1998)
  24. Re: Duplicates (Brian B. Burton 1998)
  25. Re: Duplicates (Dave MacLeay 1998)
  26. Re: Duplicates (Brian B. Burton 1998)
  27. Re: Duplicates (Kenneth Grome 1998)
  28. Re: Duplicates (Peter Ostry 1998)
  29. Re: Duplicates (Brian B. Burton 1998)
  30. Re: Duplicates (Kenneth Grome 1998)
  31. Duplicates (Brian B. Burton 1998)
>>>Does anyone have a good way for detecting records that have a duplicate >>>value in one field, then noting this, or deleting it? >> >>What's the purpose of this effort? Are you trying to create a keyword field >>that doesn't have duplicate values in it? Or is this for some other purpose >>entirely? > >Sorry, I should have been more specific with my request. >I have a database with 4 fields. ID, Email, adddate, promostatus..To be even more specific, is there *ever* more than one email address in the Email field?Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Kenneth Grome

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:

WebCat2 - Getting to the browser's username/password data (1997) lookup command (1997) WebCat2: Items xx to xx shown, etc. (1997) More help for discount pricing (1998) problems with 2 tags (1997) problems with 2 tags (1997) Simple way to create unique SKU (1997) Newbie search question (between two dates) (2001) Emailer (1998) WebDNA 5.1 is now available! (2003) Thanks ! (1997) Big Databases (1997) SERIAL NUMBER PROBLEM *AGAIN*!!! (1998) Cart -> Date and Time (2004) WC2b15 File Corruption (1997) headers (2000) problems with 2 tags (1997) simple answer? [hideif] (1997) Newbie HW/SW Setup Question (2000) Multiple prices (1997)