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]]
[append table=idandemail]ie_ID=[db_ID]&ie_EMAIL=[url][db_EMAIL][/url][/append]

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

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


Top Articles:

Tips and Tricks

A list of user-submitted tips ...

WebDNA Modules

A list of the currently available modules...


A compilation of some user's questions...


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


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