[thelist] ASP login

Giulio Mastrosanti giulio at cantoberon.it
Mon Jan 14 09:22:00 CST 2002


> 
> sqlString = "SELECT user_id FROM users " &_
>           "WHERE user_username='" & username & "' " &_
>           "AND user_password='" & password & "' "
> "AND user_dnumber='" & dnumber & "' "
> Set RS = Con.Execute(sqlString)
> 

Don't know about asp (i use php) but it seems it need the & at the end of
the second line. So looking the first example ( it works, no?) should be:

sqlString = "SELECT user_id FROM users " &_
            "WHERE user_username='" & username & "' " &_
            "AND user_password='" & password & "' " &_
            "AND user_dnumber='" & dnumber & "'

Hope this helps,


     Giulio





More information about the thelist mailing list