Re: Duplicates

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17774
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.-Daveo--------------- Dave MacLeay --+ o----------- Digital Frontier --+ o--- dave@digitalfrontier.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.-Daveo--------------- Dave MacLeay --+ o----------- Digital Frontier --+ o--- dave@digitalfrontier.com --+ Dave MacLeay

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:

Director 7 (1999) sort problems....bug or brain fart? (1997) [WebDNA] [BULK] WebDNA 7 & Amazon Cloud (2011) No Access warning when caching HTML files (1997) about this server and links to who (1997) Help!!!! (1999) WebCat & WebTen (1997) Error Page? (1997) listfiles-looking for slick solution (1997) [WebDNA] making all fields on a form mandatory (2013) error: Too many nested [xxx] contexts (1997) Changes to the List (1997) WebMerchant 1.6 and SHTML (1997) setting username and password using a form. (2000) multiple databases (1997) RE: ANother SHOWIF problem (1997) [WebDNA] inputed text getting scrambled up in DB (2012) Re:quit command on NT (1997) Further tests with the infamous shipCost (1997) Commas in search (1998)