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:

WCS Newbie question (1997) Logging purchases (1997) Re:listfiles-looking for slick solution (1997) WC 3.0.1 Mac days_to_date (1998) syntax question, not in online refernce (1997) Username for Admin Group (1997) Am I going senile? (Price recalc based on quantity) (1997) [WebDNA] how to clear the [username] and [password] values the browser has stored? (2008) Parameter Passing Value (2002) Searchable WebCat (etc.) Docs ? (1997) Emailer help....! (1997) Three new problems, maybe a fourth (1997) Solution: Replace/Commit not Replacing/Commiting (2000) Hiccup ***** (1998) WebCat2 Append problem (B14Macacgi) (1997) [WebDNA] IP Address to country (2008) Word Bolding (1996) remotely add + sign (1997) Re:WebCatalog/WebMerchant III (1998) Unable to view next 101-200 (1997)