Case sensitive password 1

[randall2nd]

I am trying to create a login page. Everything works, except I do not know how to make the password case sensitive. I am using an Access DB to store the info. I am new to CF, so I do not know if this is a CF problem or a database problem. I need the login to recognize that 'hoRsE' is not the same as 'Horse'.

ANY help would be appreciated.

 

[kristof]

Hi randall2nd,

As far as i know the SQL statements are case insensitive, but the results it produces are!

And if you should wanna check with CF you can use this:

<cfif Compare(var1, var2) is 0>
Password matches
</cfif>

Hope I got you any further?

kristof

 

[randall2nd]

Thank You, that works great!