[thelist] sql for mailing list verify

.jeff jeff at members.evolt.org
Thu Jul 25 20:43:01 CDT 2002


> From: Drew Psconi
> I'm using ASP but I see how that relates.  I figured
> there may be a SQL command for it but I guess it doesn't
> matter as long as it works.  Thanks!

there's a way you can do it in sql.  it's as simple as placing a constraint on the email column mandating that every value must be unique.  then, go ahead and attempt your insert. you'll need to wrap the query call in some form of error trapping code.  if no message comes back then it was successful.  if there's a message then an entry with that email address already exists and you need to tell the user.


jeff at members.evolt.org

More information about the thelist mailing list