[thelist] ASP login
Faye Tarzwell (FayeC)
ftarzwell at fayec.com
Mon Jan 14 09:12:23 CST 2002
Hi,
I am trying to create a login where 3 conditions are needed instead of
2.
In a 2 condition login the statement is like:
sqlString = "SELECT admin_id FROM admin " &_
"WHERE admin_username='" & username & "' " &_
"AND admin_password='" & password & "' "
Set RS = Con.Execute(sqlString)
I am using two AND like:
sqlString = "SELECT user_id FROM users " &_
"WHERE user_username='" & username & "' " &_
"AND user_password='" & password & "' "
"AND user_dnumber='" & dnumber & "' "
Set RS = Con.Execute(sqlString)
But I keep getting :
Microsoft VBScript compilation error '800a0400'
Expected statement
/magazine/validations.asp, line 7
"AND user_dnumber='" & dnumber & "' "
^
Should I use something different instead of the AND?
Thanks,
--
Flavia Tarzwell (FayeC)
More information about the thelist
mailing list