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.1222156217131Content-Type: text/plain; charset=UTF-8Content-Transfer-Encoding: 7bitContent-Disposition: inlineThanks guys,I ended up using a mixture of all the ideas, I wanted to show all recordswith duplicate email addresses so the user can then decide which one todelete. The code I'm using is not pretty but it works - I'll try to refineit.The first search sets up a table with the email duplicates - but thisdoesn't include the initial email that the comparison is based on. Thesecond search goes through this table and summarises the email field - thefinal search searches the original database to ensure that all records withduplicate 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][searchtable=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.1222156217131Content-Type: text/html; charset=UTF-8Content-Transfer-Encoding: 7bitContent-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:
------=_Part_20387_7878879.1222156217131Content-Type: text/plain; charset=UTF-8Content-Transfer-Encoding: 7bitContent-Disposition: inlineThanks guys,I ended up using a mixture of all the ideas, I wanted to show all recordswith duplicate email addresses so the user can then decide which one todelete. The code I'm using is not pretty but it works - I'll try to refineit.The first search sets up a table with the email duplicates - but thisdoesn't include the initial email that the comparison is based on. Thesecond search goes through this table and summarises the email field - thefinal search searches the original database to ensure that all records withduplicate 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][searchtable=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.1222156217131Content-Type: text/html; charset=UTF-8Content-Transfer-Encoding: 7bitContent-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]
[table name=duplist&fields=RID,DUPEMAIL]
[/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:
Mac Vs WindowsNT (1997)
Summing fields (1997)
E-Commerce site for Canadian and US customers (1998)
In Digest Dijon (2000)
Cart Database (1999)
Using EIMS instead of Emailer (1998)
webcat- multiple selection in input field (1997)
Fun with dates (1997)
bugs w/! &/or bad scripting??? (1997)
Virtual hosting and webcatNT (1997)
[Listfiles] vs Netfinder (1997)
Re:quit command on NT (1997)
Server crash (1997)
creating a ShipCosts database (1997)
RE: Answer: WebDelivery downloads alias, not original ? (1997)
formulas.db and prices (1999)
Deleting Orders (1997)
Problem 2 of 2 (was: Shipping Confusion) (2000)
WCS Newbie question (1997)
Requiring that certain fields be completed (1997)