[thelist] server side validation

[Kevin Greene]

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 !