creating a register user page?
-
hi, i was going to use the ibuyspy example of registering a new user but for some reason my version of the code will let duplicate emails into the database?? im not sure why?? Any way I wondered if any of you guys could point me in the right direction regarding registering a new user page? My login page works fine ...but this register page is giving me a headache!! Thanks in advance! Jetset:-D
-
hi, i was going to use the ibuyspy example of registering a new user but for some reason my version of the code will let duplicate emails into the database?? im not sure why?? Any way I wondered if any of you guys could point me in the right direction regarding registering a new user page? My login page works fine ...but this register page is giving me a headache!! Thanks in advance! Jetset:-D
jetset32 wrote: my version of the code will let duplicate emails into the database?? im not sure why?? Add a unique constraint to the database column. Then if you attempt an INSERT or UPDATE with a duplicate email then the operation will fail and you can catch the SqlException Alternatively, you can write a stored procedure that does a check first and returns a success code back if the check passed and the record was INSERTed or UPDATEed. jetset32 wrote: but this register page is giving me a headache!! For details on ASP.NET see the ASP.NET forum. Unless the thing giving you the headache is database related :-D
Do you want to know more? WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums