SELECT FROM help
Hi everyone,
I am new to this group so if I have missed the answer to this question I am sorry.
I have a login page using an access database to verify username.
when I use the like statement it returns the correct data but I need it to =the username in the table.
this is the code:
qry = "SELECT * FROM userlist WHERE username = '" & Request.Form("txtUserName") & "%'"
Set oRS = oConn.Execute(qry)
if not oRS.EOF then
while not oRS.EOF
response.write ("Welcome. "& oRs.Fields(username) & " <br>")
oRS.movenext
wend
else response.Write("Username not found.")
oRS.close
end if
Can someone help me with this please?
Thanks,
Dink
|
