Re: [WebDNA] Finding duplicate records
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 107419
interpreted = N
texte = --Apple-Mail=_ECBC90DE-6552-4AA6-AE1D-BB3667CE2311 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Tom This is what i use. [math show=3Df]linecount=3D0[/math] [Text]prevrecord=3Dnoemailaddress[/Text] [Search = db=3D^data/directcustomers.db&neDEDUPEIDdata=3Dfind_all&neEMAILdatarq=3D[b= lank]&DEDUPEIDtype=3Dnum&asEMAILsort=3D1] There are [numfound] total customer records
Following is a list of duplicate emails, click on 'show details' to = manage the records
[FoundItems] [ShowIf [URL][EMAIL][/URL]=3D[URL][prevrecord][/URL]] [math show=3DF]linecount=3D[linecount]+1[/math] [email]
[/ShowIf] [Text]prevrecord=3D[email][/Text] [/FoundItems] [/Search] On 23/09/2011, at 8:39 AM, Tom Duke wrote: > Hi all, >=20 > Does anyone have a super smart method for finding duplicate records in = a database. Specifically where more than one record contains the same = email address. >=20 > Thanks > - Tom > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us --Apple-Mail=_ECBC90DE-6552-4AA6-AE1D-BB3667CE2311 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii [math = show=3Df]linecount=3D0[/math][Search = db=3D^data/directcustomers.db&neDEDUPEIDdata=3Dfind_all&neEMAILdat= arq=3D[blank]&DEDUPEIDtype=3Dnum&asEMAILsort=3D1]
There = are [numfound] total customer records<br>
Following is a list of duplicate = emails, click on 'show details' to manage the records
[FoundItems]
[ShowIf = [URL][EMAIL][/URL]=3D[URL][prevrecord][/URL]]
[math = show=3DF]linecount=3D[linecount]+1[/math]
[email]<br>
[/ShowIf]
[/FoundItems]
On 23/09/2011, = at 8:39 AM, Tom Duke wrote:
Hi all,
Does anyone have a super smart method for finding = duplicate records in a database. Specifically where more than one = record contains the same email = address.
Thanks
- Tom
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us
= --Apple-Mail=_ECBC90DE-6552-4AA6-AE1D-BB3667CE2311--
Associated Messages, from the most recent to the oldest:
--Apple-Mail=_ECBC90DE-6552-4AA6-AE1D-BB3667CE2311 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Tom This is what i use. [math show=3Df]linecount=3D0[/math] [text]prevrecord=3Dnoemailaddress[/Text] [Search = db=3D^data/directcustomers.db&neDEDUPEIDdata=3Dfind_all&neEMAILdatarq=3D[b= lank]&DEDUPEIDtype=3Dnum&asEMAILsort=3D1] There are [numfound] total customer records
Following is a list of duplicate emails, click on 'show details' to = manage the records
[founditems] [ShowIf [url][EMAIL][/URL]=3D[url][prevrecord][/URL]] [math show=3DF]linecount=3D[linecount]+1[/math] [email]
[/ShowIf] [text]prevrecord=3D[email][/Text] [/FoundItems] [/Search] On 23/09/2011, at 8:39 AM, Tom Duke wrote: > Hi all, >=20 > Does anyone have a super smart method for finding duplicate records in = a database. Specifically where more than one record contains the same = email address. >=20 > Thanks > - Tom > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us --Apple-Mail=_ECBC90DE-6552-4AA6-AE1D-BB3667CE2311 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii [math = show=3Df]linecount=3D0[/math][text]prevrecord=3Dnoemailaddress[/Text]
[Search = db=3D^data/directcustomers.db&neDEDUPEIDdata=3Dfind_all&neEMAILdat= arq=3D[blank]&DEDUPEIDtype=3Dnum&asEMAILsort=3D1]
There = are [numfound] total customer records<br>
Following is a list of duplicate = emails, click on 'show details' to manage the records
[ShowIf =
[url][EMAIL][/URL]=3D
[url][prevrecord][/URL]]
[math = show=3DF]linecount=3D[linecount]+1[/math]
[email]<br>
[/ShowIf]
[text]prevrecord=3D[email][/Text]
[/FoundItems]
On 23/09/2011, = at 8:39 AM, Tom Duke wrote:
Hi all,
Does anyone have a super smart method for finding = duplicate records in a database. Specifically where more than one = record contains the same email = address.
Thanks
- Tom
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us
= --Apple-Mail=_ECBC90DE-6552-4AA6-AE1D-BB3667CE2311--
Stuart Tremain
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:
Open source store builder (Merchant Maker?) (2003)
Show shoppingcart after remove last item (1997)
[group] ? (1997)
WebSTAR, OSX, WebDNA permissions problem ... (2005)
Webcat/Webmerchant part II (1998)
Signal Raised (1997)
3RD POST Character limit in [Search]? (1998)
Where's Cart Created ? (1997)
Sorting Numbers (1997)
Append again (1999)
WebCat2 - [format thousands] (1997)
Rhapsody? (1997)
restarting service remotely on NT (1997)
PCS Frames (1997)
CAll me Crazy (2000)
Bulk Processing Offline (2004)
Configuring E-mail (1997)
Webcat Manual and TeaRoom Examples Uses Different Examples. (1997)
quantity minimum problem (1997)
WebCat2.0 [format thousands .0f] no go (1997)