Find duplicate records

Find duplicate records and do something with them

[!] ** Untested Code below ** [/!]

[table name=idandemail&fields=ie_ID,ie_EMAIL][/table]

[search db=main.db&neDB_EMAILdatarq=[blank]]
  [founditems]
    [append table=idandemail]ie_ID=[db_ID]&ie_EMAIL=[url][db_EMAIL][/url][/append]
  [/founditems]
[/search]

[search db=main.db&neDB_EMAILdatarq=[blank]&DB_EMAILsumm=T]
  [founditems]
    [text]found=[search table=idandemail&eqIE_EMAILdatarq=[url][db_EMAIL][/url]][/search][/text]

    [!] do something based off of [found] [/!]
  [/founditems]
[/search]

DOWNLOAD WEBDNA NOW!

Top Articles:

Tips and Tricks

A list of user-submitted tips ...

WebDNA Modules

A list of the currently available modules...

F.A.Q

A compilation of some user's questions...

[biotype]

BioType is a behavioral biometrics WebDNA function based on ADGS research and development (from version 8...

Download WebDNA Applications

WebDNA applications...

Technical Change History

This Technical Change History provides a reverse chronological list of WebDNA changes...

Related Readings:

Cloning a Record

Often...

Database backup

How to make a backup of your databases...

Check the Federal Government's Social Security database

The script on the page will check the federal government's social security database...

Removing whitespace

How can I remove all whitespace entered by a user from an input box (ie card number)...

Using a simple Array of Variables with [interpret]

The [interpret] context is very powerful command in the hands of a skilled WebDNA programmer...

File upload example

...