Re: Duplicates

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17772
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?There was, but I killed them all by hand. I still keep an eye out for and or ; in this field, and go in a clean it when I find this. This whole task would be easier if we had some sort of string variables...Anyway, I guess I'm still looking for the best possible solution, because my next task will be to take similar code and clean up and maintain user/catalog request databases for several other sites I have. Brian B. Burton BOFH - Department of Redundancy Department --------------------------------------------------------------- MMT Solutions - Specializing in Online Shopping Solutions 973-808-8644 http://www.safecommerce.com 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?There was, but I killed them all by hand. I still keep an eye out for and or ; in this field, and go in a clean it when I find this. This whole task would be easier if we had some sort of string variables...Anyway, I guess I'm still looking for the best possible solution, because my next task will be to take similar code and clean up and maintain user/catalog request databases for several other sites I have. Brian B. Burton BOFH - Department of Redundancy Department --------------------------------------------------------------- MMT Solutions - Specializing in Online Shopping Solutions 973-808-8644 http://www.safecommerce.com Brian B. Burton

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:

Webmerchant confirmation hooks? (1997) WebCat NT v. Mac (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) NTbeta18 corrupted? (1997) Still ignoring the 3.x bugs? (2000) [WebDNA] New Licenses (2009) [cart] number range ?? (2001) A little syntax help (1997) removelineitems (2000) searching multiple databases (1997) Trouble with formula.db (1997) [WebDNA] OSX Yosemite (2014) Installing on IIS 5.1 Windows XP Pro - Username/Password (2006) Pass a form (2003) WebCat2b15MacPlugin - [protect] (1997) Meet your competition (2000) WebCatalog Plug-in for Webstar. (1997) Templetes? (1999) [date] insanity! (2001) Getting total number of items ordered (1997)