[thelist] server side validation
Douglas Rehg
drehg at fishcicle.com
Wed Mar 27 18:41:00 CST 2002
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 !
More information about the thelist
mailing list