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:

Convertchars Problem (2004) Search returns all, not 20 (1997) Spawning Holdup? (2000) Help! WebCat2 bug (1997) drop down menu (2000) Old code new problem? (2004) 100% CPU (2003) [append] problem (1997) no global [username] or [password] displayed ... (1997) Q: Japanese Kanji code support? (2000) Help name our technology! (1997) WebCat and WebTV (1997) WebCat cannot handle compatible search parameters? (1997) Quit revisited (1997) WebCat2 several catalogs? (1997) Individual LineItemChangePassword files would be better ... (1999) Cookies (1999) Webmerchant confirmation hooks? (1997) Re:[ShowIf] and empty fields (1997) Assign New Cart (2003)