I got one prob during my login session.
I'm using ASP and Access as my database.....................
In my login page, i have 2 textbox which will accept username and password respectively.
when i key in the username, it basically will accept capital and non-capital word with the password being true.
How do i change it so that when user key in the username, it will accept only particular case which is very much similar to the username in the database.
In other word, i want it to be case sensitive.
Can anyone help me?
actually, my asp script will do the comparison instead of the sql statement.the sql statement is just to retrieve the data only which are the username and password.
i'm not using any function to do this process coz i'm keeping it simple.
actually i'm using SQL statement to compare..........
and the code is like this
sqlCode="Select name FROM register WHERE password= '" + pswd + "' and username = '" + userID + "'"
if rs.EOF then
what do u think?