I am a bit confused here. I have a form and action page for handling a user login. Presently, my action page ignores the capitalization of the password. Whether you use lower case letters, or all caps, for the password, the action.cfm page logs you in, as long as the value is correct. I want it to ONLY login if the correct password case is used. How do I solve this?

**Form:**

```
<form name="login" target="_self" method="POST" action="action.cfm">
   Username: <input name="UserName" type="text"><br/>
   Password: <input name="Password" type="password"><br/>
   <input name="" type="submit" value="Login">
</form>

```

**action.cfm:**

```
<cfquery name="qVerify" datasource="me.mdb"> 
    SELECT  UserName, Password 
    FROM    rbs 
    WHERE   UserName = '#UserName#' 
    AND     Password = '#Password1#' 
</cfquery> 
<cfif qVerify.RecordCount> 
    <cfset session.allowin = "True"> 
    <!--- Now welcome user and redirect to "accessgranted.cfm" ---> 
    <CFLOCATION URL="successful.html"> 
<cfelse> 
    <script> 
    alert("ACCESS NOT GRANTED. CHECK YOUR LOGIN PARAMETERS."); 
    self.location="loginpage.html"; 
    </script> 
</cfif>

```