debug... Find out what you vars are...
Response.write("email")
Response.end.
right before
objAdd.Fields("email") = email
before set objAdd = Server.CreateObject ("ADODB.Recordset")
do a response.write on all you vars to make sure they are correct.
The error your getting is because email is blank.
Just an idea, but you could use a flag in the DB to tell wether the person is logged in or not. Keep track of how many users are logged in with that same username/password.
or Once the user is authenticated set a hidden page/session value that you use to see if the user is logged in or not.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.