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 tosolve any task! (and sometimes, in looking for a better solution, we avoidthe obvious ones...) This will solve the problem at hand, and do it very quickly (on the flyeven!), but I am still bummin' for the best way to maintain databases inWebCatalog, and removing duplicate records is one major requirement. In someback dusty corner of my mind, I miss Filmmakers just type an ! into a findfield 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:
>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 tosolve any task! (and sometimes, in looking for a better solution, we avoidthe obvious ones...) This will solve the problem at hand, and do it very quickly (on the flyeven!), but I am still bummin' for the best way to maintain databases inWebCatalog, and removing duplicate records is one major requirement. In someback dusty corner of my mind, I miss Filmmakers just type an ! into a findfield 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)