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:

WebCat2b15MacPlugin - showing [math] (1997) email messages (1997) WCS Newbie question (1997) WebCat2b15MacPlugIn - [authenticate] not [protect] (1997) Weird Linux WebCat Issue (2003) question: Eudora 3.1.1 (1997) WebCatalog for guestbook ? (1997) RE: New WebCatalog Version !!! (1997) [random] only for 1-100??? (1997) REALLY need a hand (1999) New commands in Final candidate (1997) What am I missing (1997) Here we go again... was: DDEConnect not working (2006) Another bug to squash (WebCat2b13 Mac .acgi) (1997) errormessages.db (1997) WebCat editing, SiteGuard & SiteEdit (1997) FAX orders (1996) wierd [cart] action! (1997) Bug Report, maybe (1997) Proper file locations (1997)