Re: [WebDNA] Finding duplicate email addresses

This WebDNA talk-list message is from

2008

It keeps the original formatting. numero = 100912
interpreted = N
texte = --=====================_822552031==.ALTContent-Type: text/plain; charset="us-ascii"This should work, not pretty but has worked for me:[search db=xxxx.db&neSKUdatarq=[blank]&asEMAILADDYsort=1][founditems][showif [EMAILADDY]=[OLDEMAILADDY2]][SKU] with EMAILADDY [EMAILADDY] is a duplicate of [OLDEMAILADDY2]
[replace db=xxxx.db&eqSKUdatarq=[Url][SKU][/Url]]Replace statement here or as needed[/replace][/showif][text show=f]OLDEMAILADDY2=[OLDEMAILADDY1][/text][text show=f]OLDEMAILADDY1=[EMAILADDY][/text][/founditems][/search]GJKAt 12:57 PM 9/22/2008, you wrote:>Hi all,>>Has anyone worked out a good way of finding duplicate entries of a value in a particular field, in this instance an email address. >>Thanks>- Tom--=====================_822552031==.ALTContent-Type: text/html; charset="us-ascii"This should work, not pretty but has worked for me:

[search db=xxxx.db&neSKUdatarq=[blank]&asEMAILADDYsort=1]
[founditems]

[showif [EMAILADDY]=[OLDEMAILADDY2]]
[SKU] with EMAILADDY [EMAILADDY] is a duplicate of[OLDEMAILADDY2]<br>
[replace db=xxxx.db&eqSKUdatarq=[Url][SKU][/Url]]Replace statementhere or as needed[/replace]
[/showif]

[text show=f]OLDEMAILADDY2=[OLDEMAILADDY1][/text]
[text show=f]OLDEMAILADDY1=[EMAILADDY][/text]

[/founditems]
[/search]

GJK

At 12:57 PM 9/22/2008, you wrote:


Hi all,

Has anyone worked out a good way of finding duplicate entries of a valuein a particular field, in this instance an email address.

Thanks
- Tom

--=====================_822552031==.ALT-- Associated Messages, from the most recent to the oldest:

Re: [WebDNA] Finding duplicate email addresses ("Tom Duke" 2008) Re: [WebDNA] Finding duplicate email addresses (Donovan Brooke 2008) Re: [WebDNA] Finding duplicate email addresses ("David Bastedo" 2008) Re: [WebDNA] Finding duplicate email addresses (Gary Krockover 2008) [WebDNA] Finding duplicate email addresses ("Tom Duke" 2008)

--=====================_822552031==.ALTContent-Type: text/plain; charset="us-ascii"This should work, not pretty but has worked for me:[search db=xxxx.db&neSKUdatarq=[blank]&asEMAILADDYsort=1][founditems][showif [EMAILADDY]=[OLDEMAILADDY2]][SKU] with EMAILADDY [EMAILADDY] is a duplicate of [OLDEMAILADDY2]
[replace db=xxxx.db&eqSKUdatarq=[url][SKU][/Url]]Replace statement here or as needed[/replace][/showif][text show=f]OLDEMAILADDY2=[OLDEMAILADDY1][/text][text show=f]OLDEMAILADDY1=[EMAILADDY][/text][/founditems][/search]GJKAt 12:57 PM 9/22/2008, you wrote:>Hi all,>>Has anyone worked out a good way of finding duplicate entries of a value in a particular field, in this instance an email address. >>Thanks>- Tom--=====================_822552031==.ALTContent-Type: text/html; charset="us-ascii"This should work, not pretty but has worked for me:

[search db=xxxx.db&neSKUdatarq=[blank]&asEMAILADDYsort=1]
[founditems]

[showif [EMAILADDY]=[OLDEMAILADDY2]]
[SKU] with EMAILADDY [EMAILADDY] is a duplicate of[OLDEMAILADDY2]<br>
[replace db=xxxx.db&eqSKUdatarq=[url][SKU][/Url]]Replace statementhere or as needed[/replace]
[/showif]

[text show=f]OLDEMAILADDY2=[OLDEMAILADDY1][/text]
[text show=f]OLDEMAILADDY1=[EMAILADDY][/text]

[/founditems]
[/search]

GJK

At 12:57 PM 9/22/2008, you wrote:


Hi all,

Has anyone worked out a good way of finding duplicate entries of a valuein a particular field, in this instance an email address.

Thanks
- Tom

--=====================_822552031==.ALT-- Gary Krockover

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:

Reserved words - Enhancement request (2000) international time (1997) PROBLEM (1997) Include a big block of text (1997) WriteFile Formatting (2000) Search bug. Search context resolved. (2002) matching shipto and others (1998) SetHeader (1997) dynamic list of form variables (2003) Deleting Orders (1997) WebDNA Intranet Edition release (2002) Narrowing NT Crashing error (2000) mail sent from webcatalog. accented chars! (1998) Setting up shop (1997) [delete] problem (1997) Showif, Hideif reverse logic ? (1997) What to do... (2000) code to phantom spacing (2001) New WebDNA Solutions ... (1997) Wrapping text (1998)