When users enter their email address and password in the login form, a login
check is made using the following code. (The password is hashed in the database)
<!--- Find record with this Email/password --->
<cfquery name="getUser" datasource="security">
SELECT email, password
WHERE email = '#FORM.email#' AND password = '#form.password#'
<cfif Hash(Form.password, "SHA") is not getUser.password>
OK, it works.
I cannot get it to return "OK , it works" for the life of me. Can anyone point
out what's incorrect?