Email validation from Database

[vimal.424@gmail.com]

Hello guys........



please tell me .............

I want to do email validation like i have a userid entered by user new
user.so problem is that i have to do the validation when i'll click on
save button b'coz userid should be unique.....


Thanks in advance

[Marc Gravell]

Re: Email validation from Database

If you just need it to be unique, then tell the database that... most
databases have a mechanism to add a unique constraint to a value, which
will prevent you doing duplicate insertions. Of course, this is a
back-stop; you can also check this in advance and do something different
if that e-mail is already registered - but /how/ to do that depends on
the scenario, and you haven't told us what that is...

Marc