数据库连接正确,用户名密码都正确,为何总跳到"fail.cfm"???
<cfquery name="Recordset1" datasource="users_tape">
SELECT user_name, pass_word FROM main
</cfquery>
<cfif IsDefined("FORM.textfield1"
>
<cfoutput>test</cfoutput>
<cfset MM_redirectLoginSuccess="ok.cfm">
<cfset MM_redirectLoginFailed="fail.cfm">
<cfquery name="MM_rsUser" datasource="users_tape">
SELECT user_name,pass_word FROM main WHERE user_name='#FORM.textfield1#' AND pass_word='#FORM.textfield2#'
</cfquery>
<cfif MM_rsUser.RecordCount NEQ 0>
<cftry>
<cflock scope="Session" timeout="30" type="Exclusive">
<cfset Session.MM_Username=FORM.textfield1>
<cfset Session.MM_UserAuthorization="">
</cflock>
<cfif IsDefined("URL.accessdenied"
AND false>
<cfset MM_redirectLoginSuccess=URL.accessdenied>
</cfif>
<cflocation url="#MM_redirectLoginSuccess#" 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 & "?" & XMLFormat(CGI.QUERY_STRING)>
</cfif>
</cfif>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>Confirm</title>
</head>
<body>
<form name="form1" method="POST" action="<cfoutput>#MM_loginAction#</cfoutput>">
<p>
<input name="textfield1" type="text" id="textfield1">
</p>
<p>
<input name="textfield2" type="password" id="textfield2">
</p>
<p>
<input type="submit" name="Submit" value="提交">
<input type="reset" name="Submit" value="重置">
</p>
</form>
</body>
</html>