...

View Full Version : makeing compareson case sensetive



Phip
08-15-2002, 04:49 AM
How would i make something like this case sensetive?

strSQL = "SELECT * FROM user_key WHERE username='" & Request.Form("username") & "' And password='" & Request.Form("password") &"';"

so if the it doesn't match case sensetive it will return EOF

oracleguy
08-15-2002, 05:42 AM
Originally posted by Phip
How would i make something like this case sensetive?

strSQL = "SELECT * FROM user_key WHERE username='" & Request.Form("username") & "' And password='" & Request.Form("password") &"';"

so if the it doesn't match case sensetive it will return EOF

If you use a rs("Password")=Request.Form("Password")

then it will be case sensitive... i think. 'rs' is whatever your recordset is.

Phip
08-16-2002, 02:27 AM
thanks.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum