[thelist] server side validation
Kevin Greene
sinnot at iol.ie
Wed Mar 27 18:50:01 CST 2002
You could always allow the email address to go through and use the DISTINCT
keyword
E.g.
SELECT DISTINCT email_address
FROM TableName
Regards.
Kevin
WebDev Ltd
Parteen, Nr. Limerick, Ireland.
Tel: 087-2456123
Email: sinnot at iol.ie
On Thursday, March 28, 2002 12:35 AM, George Klingenhoffer
[SMTP:georgeklingenhoffer at hotmail.com] 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