Find duplicate records

Find duplicate records and do something with them

numero = 207
interpreted = N
texte =

[!] ** 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]

[!] ** 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:

Technical Change History

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

Download WebDNA Applications

WebDNA applications...

Tips and Tricks

A list of user-submitted tips ...

WebDNA Modules

A list of the currently available modules...

WebDNA Libraries

A list of available libraries for WebDNA...

AWS Raw WebDNA LAMP-Plus WebServer

Amazon Web Services (AWS) README for Machine Image ID...

Related Readings:

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...

Export data to Excel

Here's a handy way to export your data to a text or Excel file...

Cloning a Record

Often...

How to keep the text variable after a function has finished

By default...

Extracting the first sentence out of a block of text

I need to extract the first sentence out of a block of text...