help needed to validate 2 users at once

hi all, i want to ask about validating 2 users (2 userids and 2 pws) with one button. my database table called login and it has loginId and password.

have tried

"SELECT * FROM login Where loginId = '" + hoName + "', '" + toName + "' AND password = '" + hoPassword + "', '" + toPassword + "'"

please help me!!

i'm using 03 to build, theres no errors. but when i view in browser and try to validate. a wole lot of errors come out.

|||

hi all, can anyone help me please?

|||

I didnt get u r question. Can u explain in detail. You want to check the two users and their passwords at a time or what. Clarity is required.If u give the reply i can try out and i will try to give the solution

Thank u

Baba

|||

SELECT COUNT(*)

FROM Users

WHERE (UserID=@.UserID1 ANDPWD=@.PWD1) OR (UserID=@.UserID2 ANDPWD=@.PWD2)

|||

thanks all.