Re: [WebDNA] Finding duplicate email addresses

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 100916
interpreted = N
texte = ------=_Part_20387_7878879.1222156217131 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline Thanks guys, I ended up using a mixture of all the ideas, I wanted to show all records with duplicate email addresses so the user can then decide which one to delete. The code I'm using is not pretty but it works - I'll try to refine it. The first search sets up a table with the email duplicates - but this doesn't include the initial email that the comparison is based on. The second search goes through this table and summarises the email field - the final search searches the original database to ensure that all records with duplicate emails are shown. Its taking a couple of seconds to go through a list of about 9000 records. - Tom [search db=some.db&neRIDdatarq=find_all&asEMAILsort=1] [text]prevRecord=NADA[/text] [table name=duplist&fields=RID,DUPEMAIL] [founditems][showif [url][prevRecord][/url]=[url][EMAIL]][RID] [EMAIL] [/showif][text]prevRecord=[EMAIL][/text][/founditems][/table] [/search] [search table=duplist&neRIDdatarq=find_all&asEMAILsort=1&EMAILsumm=T][founditems] [search db=somedb.db&eqEMAILdatarq=[DUPEMAIL][showif [url][DUPEMAIL][/url]=][blank][/showif]][founditems] [RID] [EMAIL] [/founditems][/search] [/founditems][/search] ------=_Part_20387_7878879.1222156217131 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Thanks guys,

I ended up using a mixture of all the ideas, I wanted to show all records with duplicate email addresses so the user can then decide which one to delete.  The code I'm using is not pretty but it works - I'll try to refine it.  

The first search sets up a table with the email duplicates - but this doesn't include the initial email that the comparison is based on.  The second search goes through this table and summarises the email field - the final search searches the original database to ensure that all records with duplicate emails are shown.

Its taking a couple of seconds to go through a list of about 9000 records.

- Tom



[search db=some.db&neRIDdatarq=find_all&asEMAILsort=1]

[text]prevRecord=NADA[/text]
[table name=duplist&fields=RID,DUPEMAIL]
[founditems][showif [url][prevRecord][/url]=[url][EMAIL]][RID][EMAIL]
[/showif][text]prevRecord=[EMAIL][/text][/founditems][/table]

[/search]

[search table=duplist&neRIDdatarq=find_all&asEMAILsort=1&EMAILsumm=T][founditems]
[search db=somedb.db&eqEMAILdatarq=[DUPEMAIL][showif [url][DUPEMAIL][/url]=][blank][/showif]][founditems]

[RID] [EMAIL]

[/founditems][/search]
[/founditems][/search]
------=_Part_20387_7878879.1222156217131-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Finding duplicate email addresses ("Tom Duke" 2008)
  2. Re: [WebDNA] Finding duplicate email addresses (Donovan Brooke 2008)
  3. Re: [WebDNA] Finding duplicate email addresses ("David Bastedo" 2008)
  4. Re: [WebDNA] Finding duplicate email addresses (Gary Krockover 2008)
  5. [WebDNA] Finding duplicate email addresses ("Tom Duke" 2008)
------=_Part_20387_7878879.1222156217131 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline Thanks guys, I ended up using a mixture of all the ideas, I wanted to show all records with duplicate email addresses so the user can then decide which one to delete. The code I'm using is not pretty but it works - I'll try to refine it. The first search sets up a table with the email duplicates - but this doesn't include the initial email that the comparison is based on. The second search goes through this table and summarises the email field - the final search searches the original database to ensure that all records with duplicate emails are shown. Its taking a couple of seconds to go through a list of about 9000 records. - Tom [search db=some.db&neRIDdatarq=find_all&asEMAILsort=1] [text]prevRecord=NADA[/text] [table name=duplist&fields=RID,DUPEMAIL] [founditems][showif [url][prevRecord][/url]=[url][EMAIL]][RID] [EMAIL] [/showif][text]prevRecord=[EMAIL][/text][/founditems][/table] [/search] [search table=duplist&neRIDdatarq=find_all&asEMAILsort=1&EMAILsumm=T][founditems] [search db=somedb.db&eqEMAILdatarq=[DUPEMAIL][showif [url][DUPEMAIL][/url]=][blank][/showif]][founditems] [RID] [EMAIL] [/founditems][/search] [/founditems][/search] ------=_Part_20387_7878879.1222156217131 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Thanks guys,

I ended up using a mixture of all the ideas, I wanted to show all records with duplicate email addresses so the user can then decide which one to delete.  The code I'm using is not pretty but it works - I'll try to refine it.  

The first search sets up a table with the email duplicates - but this doesn't include the initial email that the comparison is based on.  The second search goes through this table and summarises the email field - the final search searches the original database to ensure that all records with duplicate emails are shown.

Its taking a couple of seconds to go through a list of about 9000 records.

- Tom



[search db=some.db&neRIDdatarq=find_all&asEMAILsort=1]

[text]prevRecord=NADA[/text]
[table name=duplist&fields=RID,DUPEMAIL]
[founditems][showif [url][prevRecord][/url]=[url][EMAIL]][RID][EMAIL]
[/showif][text]prevRecord=[EMAIL][/text][/founditems][/table]

[/search]

[search table=duplist&neRIDdatarq=find_all&asEMAILsort=1&EMAILsumm=T][founditems]
[search db=somedb.db&eqEMAILdatarq=[DUPEMAIL][showif [url][DUPEMAIL][/url]=][blank][/showif]][founditems]

[RID] [EMAIL]

[/founditems][/search]
[/founditems][/search]
------=_Part_20387_7878879.1222156217131-- "Tom Duke"

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:

Resume Catalog ? (1997) More EudoraPro Email Options (1998) A question on sub-categories (1997) Error Messages Returned to User (1997) emailer stuck (1997) Help name our technology! I found it (1997) [WebDNA] snow (2009) More Shopping Cart Problems (2000) Bad spawn! Finish your work! (2002) Cancel Subscription (1996) rename a file (1997) Emailer problems. (1998) Migrating to NT (1997) Appending Record Prob (2001) [OT] HTML Table Cell Problem (2003) Re:no [search] with NT (1997) Practice runs ? (1997) Emailer setup (1997) URGENT: NO BUG, woFIELDdata & FIELDword=ww (2002) Help formatting search results w/ table (1997)