[thelist] ASP login

[Faye Tarzwell (FayeC)]

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)