[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


SELECT DISTINCT email_address
	FROM TableName


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