Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

verify login in case-sensitive

Status
Not open for further replies.

cumap

IS-IT--Management
Jul 9, 2007
268
0
0
US
Hello,

I'm trying to verify login username and password in case-sensitive comparing with data from MS Access database source. Understanding unlike JS, ASP is not case-sensitive script, but I believe there must be a way to make this login verification works with case-sensitive.

Thank you.
 
Thanks anyway, but I did found out how to do so and here it is:
Code:
sql = "SELECT * FROM AdminUsers WHERE user_active = '1'"
Set rs = objConn.Execute(sql)
Do While NOT rs.eof
	if StrComp(rs("username"),sUsername,vbBinaryCompare)=0 AND StrComp(rs("password"),sPassword,vbBinaryCompare)=0 then
             Session("validUser")= True
        end if
rs.movenext
Loop
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top