case sensitive

Results 1 to 2 of 2

Thread: case sensitive

  1. #1
    Join Date
    Dec 1969

    Default case sensitive

    how can i make my login case sensitive?<BR>here is my basic code<BR><BR>strUser = Request.Form("username")<BR>strPass = Request.Form("password")<BR><BR>strSQL = "SELECT * FROM testtable WHERE strUsername=&#039;" & strUser & "&#039; AND strPassword=&#039;" & strPass & "&#039;"<BR>Set RS = Conn.Execute(strSQL)<BR><BR>this code is not case sensitive<BR>how would i make it?????<BR>thanks :)

  2. #2
    Join Date
    Dec 1969

    Default Compare it after the fact

    If strPassword = rs("password") Then<BR><BR>You&#039;ll get case sensitivity that way. You ain&#039;t gettin&#039; it in SQL unless you installed it that way &#060;which you didn&#039;t, so forget that as an option&#062;

Posting Permissions

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