Re: Duplicates

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17775
interpreted = N
texte = >At 10:55 PM 5/18/98, Brian B. Burton wrote: >>Sorry, I should have been more specific with my request. >>I have a database with 4 fields. ID, Email, adddate, promostatus.. >>This will be used to send out mass mailings of specials and site >>announcements. >>(you have to sign up on the site, no spam.) Anyway, I want to check for >>duplicate email addresses, because whiny people pop up out of the wood work >>if heaven forbid they should get 2 copies of a piece of email. While I am >>writing the areas to manually enter names into the database to prevent >>duplicates, occasionally bulk names (from the companies accounting system) >>will be dumped in, and I want to run this as a preventative measure. > >If you're using Emailer to send out your bulk e-mail, you can eliminate >duplicates at send time by including Emailsumm=t in your search parameters. > >This won't remove the duplicates from the database, but should solve your >problem.Doh!I hadn't thought of this either! There always seem to be so many ways to solve any task! (and sometimes, in looking for a better solution, we avoid the obvious ones...) This will solve the problem at hand, and do it very quickly (on the fly even!), but I am still bummin' for the best way to maintain databases in WebCatalog, and removing duplicate records is one major requirement. In some back dusty corner of my mind, I miss Filmmakers just type an ! into a find field and up pop the duplicates ease of use. 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)
>At 10:55 PM 5/18/98, Brian B. Burton wrote: >>Sorry, I should have been more specific with my request. >>I have a database with 4 fields. ID, Email, adddate, promostatus.. >>This will be used to send out mass mailings of specials and site >>announcements. >>(you have to sign up on the site, no spam.) Anyway, I want to check for >>duplicate email addresses, because whiny people pop up out of the wood work >>if heaven forbid they should get 2 copies of a piece of email. While I am >>writing the areas to manually enter names into the database to prevent >>duplicates, occasionally bulk names (from the companies accounting system) >>will be dumped in, and I want to run this as a preventative measure. > >If you're using Emailer to send out your bulk e-mail, you can eliminate >duplicates at send time by including Emailsumm=t in your search parameters. > >This won't remove the duplicates from the database, but should solve your >problem.Doh!I hadn't thought of this either! There always seem to be so many ways to solve any task! (and sometimes, in looking for a better solution, we avoid the obvious ones...) This will solve the problem at hand, and do it very quickly (on the fly even!), but I am still bummin' for the best way to maintain databases in WebCatalog, and removing duplicate records is one major requirement. In some back dusty corner of my mind, I miss Filmmakers just type an ! into a find field and up pop the duplicates ease of use. 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:

Bug or syntax error on my part? (1997) Is there an easier way? (1998) Re1000001: Setting up shop (1997) RE: Multithreading of [replace] (1999) no template caching (1997) Creating folders and deleting files (1997) wc 2 pro users - sites, quotes wanted (1997) Professional WebDNA Hosting Solutions (2005) New commands in Final candidate (1997) Nested tags count question (1997) [WebDNA] eCommerce in 7.0 but not in 7.1? (2012) RequiredFields template (1997) FYI: Error message (1996) Searching (second post) (1999) WebCat2 - Getting to the browser's username/password data (1997) Unexpected error (1997) Plugin or CGI or both (1997) referrer and no caches (1997) international time (1997) Size issues (2001)