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:

Web requests in que... (2007) formatting dates from a field ... (1997) Requiring that certain fields be completed (1997) Apache suffix mapping for .tpl (2000) Secure Server (1997) Limitations on fields? Server is crashing (1997) Initiating NewCart (1997) Emailer on NT CAN'T handle large email files (1997) Practice runs ? (1997) [WebDNA] passing a variable in an include - precedence (2017) Webstar 1.3.1 PPC (1997) db access problem after switching to SSL (2001) (2000) Plugin or CGI or both (1997) SKU lookup (1997) Logging purchases (1997) Virtual hosting and webcatNT (1997) no time stamp & different times from emailer (1998) [WebDNA] Serious sendmail problems in 8.02 and 8.1 (2015) WebCat2b15MacPlugin - showing [math] (1997)