so my problem is that every time i test it i get redirected to the wrong
password page i'm sure that my passwords are correct etc
this is the code that the extension generates


<cfif IsDefined("FORM.textfield")>
<cfset MM_redirectURLLoginSuccess="">
<cfset MM_RedirectCol="redir">
<cfset MM_AuthLevelCol="">
<cfset MM_redirectLoginFailed="index.htm">
<cfquery name="MM_rsUser" datasource="login">
SELECT Usr,Pwd,redir FROM users WHERE Usr='#FORM.textfield#' AND
Pwd='#FORM.textfield2#'
</cfquery>
<cfif MM_rsUser.RecordCount NEQ 0>
<cftry>
<cflock scope="Session" timeout="30" type="Exclusive">
<cfset Session.MM_Username=FORM.textfield>
<cfset Session.MM_UserAuthorization="">
</cflock>
<cfif IsDefined("URL.accessdenied") AND false>
<cfset MM_redirectURLLoginSuccess=URL.accessdenied>
</cfif>
<cfif len(trim("redir")) GT 0>
<cfset MM_redirectURLLoginSuccess=MM_rsUser.redir[1]>
</cfif>
<cflocation url="#MM_redirectURLLoginSuccess#" addtoken="no">
<cfcatch type="Lock">
<!--- code for handling timeout of cflock --->
</cfcatch>
</cftry>
</cfif>
<cflocation url="#MM_redirectLoginFailed#" addtoken="no">
<cfelse>
<cfset MM_LoginAction=CGI.SCRIPT_NAME>
<cfif CGI.QUERY_STRING NEQ "">
<cfset MM_LoginAction=MM_LoginAction & "?" & CGI.QUERY_STRING>
</cfif>
</cfif>