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:

Still can't upgrade users.db to 2.1.1 (1998) Emailer problems (1998) How do I get WebCatalog to interpret WebDNA tags in .html files? (1997) Client-side Image Maps and WebCat? (1998) Cumulative Shipping charge calculations - your help please. (1997) Re:quit command on NT (1997) serial number (1998) WebCatalog keeps quiting on Solaris, and support isn't su (2000) New Image Gallery using WebDNA and ImageMagick (2003) Prevent multiple appends with Reload Button (1997) Generating Report Totals (1997) ReadDateFormat (1998) japanese characters (1997) Error Lob.db records error message not name (1997) two forms of delivery (1998) [WriteFile] problems (1997) date tag not interpreted (2000) WebCatalog for guestbook ? (1997) WebCat2 - [format thousands] (1997) Errata: WCS Newbie question (1997)