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 eliminateduplicates at send time by including Emailsumm=t in your search parameters.This won't remove the duplicates from the database, but should solve yourproblem.-Daveo--------------- Dave MacLeay --+o----------- Digital Frontier --+o--- dave@digitalfrontier.com --+
Associated Messages, from the most recent to the oldest:
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 eliminateduplicates at send time by including Emailsumm=t in your search parameters.This won't remove the duplicates from the database, but should solve yourproblem.-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)