Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Registered User
    Join Date
    Jun 2002
    Location
    Arizona
    Posts
    175
    Thanks
    0
    Thanked 0 Times in 0 Posts

    makeing compareson case sensetive

    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

  • #2
    Rockstar Coder
    Join Date
    Jun 2002
    Location
    USA
    Posts
    9,074
    Thanks
    1
    Thanked 328 Times in 324 Posts

    Re: makeing compareson case sensetive

    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.

  • #3
    Registered User
    Join Date
    Jun 2002
    Location
    Arizona
    Posts
    175
    Thanks
    0
    Thanked 0 Times in 0 Posts
    thanks.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •