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:
form data submission gets truncated (1997)
Great product and great job ! (1997)
[WebDNA] WebDNA7 config help (2012)
Not really WebCat (1997)
apostrophe in search item (1997)
Multi-processor Mac info ... (1997)
[shippingtotal] in Formulas.db (2002)
4.0 send email ticks. . (2000)
[delete] problem (1997)
Custom Shipping Charges (1997)
More DateMath problems (1997)
Problems with [Applescript] (1997)
Seeking Better Display of results... (1997)
Not seeing cart info on Invoice.tmpl (was PROBLEM) (1997)
[OT] Indexing of dynamic web sites (2003)
problem: mail changed (1997)
Download URL & access on the fly ? (1997)
Cyberstudio and WebDNA (1997)
Firesite cache vs webcat cache (1997)
RE: PIXO support (1997)