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

What happens if you execute that query inside your database? Does it return the correct data?

Also this:
oRs.Fields(username)

should be
oRs.Fields("username")



-----------------------------------------------------------
I will only tell you how to do it, not do it for you.------------
Unless, of course, you want to hire me to do work for you.---
^^Thats my signature--------------------------------------
-----------------------------------------------------------
http://www.catb.org/~esr/faqs/smart-questions.html -------
^^Took that from planoie's profile--------------------------
-----------------------------------------------------------

This line is suspect:

qry = "SELECT * FROM userlist WHERE username = '" & Request.Form("txtUserName") & "%'"

Are you expecting a percentage sign at the end of your entries in the username field?


Woody Z
http://www.learntoprogramnow.com

From a SQL perspective, the % sign works as a wild card with the LIKE but shouldn't be used to test whether the username matches exactly. You might consider pushing both sides of the comparison to UPPER to get past case-sensitivity issues in your test too.

Thank you all for your help. Removing the % did the trick.
The login needs to check for case sensitive.
You are wonderful!
dink