Case sensitive password logins

Not only can you protect a portion of your site with usernames and passwords, but you can also verify case sensitive passwords. Here's how you do it:

login.cfm

<cfform name="login" action="login_process.cfm" method="post">
   Username: <cfinput type="text" name="user"><br />
   Password: <cfinput type="password" name="pass"><br />
   <cfinput type="button" name="submit" value="Login">
</cfform>

login_process.cfm

<cfquery name="qVerify" datasource="your_dsn">
SELECT      id, username, password
FROM      users
WHERE      username = '#FORM.username#'
AND         password = '#FORM.password#'
</cfquery>

<cfif qVerify.RecordCount>
   <cfset verifyCase = Compare(FORM.password, qVerify.password)>
   <cfif verifyCase EQ 0>
      <!--- Verification is good. Login. --->
   <cfelse>
      <!--- Case does not match. Throw error. --->
   </cfif>
</cfif>

No comments yet.

(will not be published)
Leave this field empty: