[thelist] server side validation

[Douglas Rehg]

Why not make the address the primary key, and use a try/catch statement to
catch the error.

At 04:34 PM 3/27/02 -0800, you wrote:
>I'm working on a mailing list feature; how do I check for duplicate email
>addresses in the Access database while adding if it does not exist or throw
>up an error message if it does.
>
>Would that require two SQL statements?  One to query every address and
>compare the address to be added to each address in the database then one to
>add the address or is there a single SQL statement for this?  Thanks!
>
>
>--
>For unsubscribe and other options, including
>the Tip Harvester and archive of thelist go to:
>http://lists.evolt.org Workers of the Web, evolt !