帮我看看我的脚本为什么查询不到结果
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/cnn.asp" -->
<%
var Recordset1__MMColParam1 = "1";
if (String(Request.Form("acct_id")) != "undefined" &&
String(Request.Form("acct_id")) != "") {
Recordset1__MMColParam1 = String(Request.Form("acct_id"));
}
%>
<%
var Recordset1__MMColParam2 = "1";
if (String(Request.Form("region_name")) != "undefined" &&
String(Request.Form("region_name")) != "") {
Recordset1__MMColParam2 = String(Request.Form("region_name"));
}
%>
<%
var Recordset1 = Server.CreateObject("ADODB.Recordset");
Recordset1.ActiveConnection = MM_cnn_STRING;
Recordset1.Source = "SELECT * FROM deposit_t WHERE acct_id="+ Recordset1__MMColParam1.replace(/'/g, "''") + " and region_name='"+ Recordset1__MMColParam2.replace(/'/g, "''") + "'";
Recordset1.CursorType = 0;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
var Recordset1_numRows = 0;
if (Request.QueryString!="") {
if (!Recordset1.EOF || !Recordset1.BOF){
var MM_Region_Name = Recordset1.Fields.Item("region_name").Value;
var MM_User_Name = Recordset1.Fields.Item("user_name").Value;
var MM_User_Nbr = Recordset1.Fields.Item("user_nbr").Value;
var MM_Deposit_Type = Recordset1.Fields.Item("deposit_type").Value;
var MM_Rescv_Time = Recordset1.Fields.Item("rescv_time").Value;
var MM_Charge = Recordset1.Fields.Item("charge").Value;
var MM_Acct_Id = Recordset1.Fields.Item("acct_id").Value;
var MM_Acct_Type = Recordset1.Fields.Item("acct_type").Value;}
else {%>
<script language=vbscript>
MsgBox "所选发票无记录!"
location.href = "javascript:history.back()"
</script>
<%}}
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">
<!--
body {
background-image: url(resource/backround1%20%E6%8B%B7%E8%B4%9D.jpg);
background-color: #FFFFFF;
}
-->
</style>
<style type="text/css">
<!--
.STYLE1 {color: #7B98E1}
.STYLE2 {
color: #7c99e2;
font-size: 12px;
}
-->
</style>
</head>
<body>
<form id="form1" name="form1" method="post" action="">
<table width="100%" cellspacing="0" cellpadding="0">
<tr>
<td><div align="center" class="STYLE1">
<h2>押金退款</h2>
</div></td>
</tr>
</table>
</form>
<form id="form2" name="form2" method="post" action="">
<table width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="9%"> </td>
<td width="10%"><div align="center"><span class="STYLE2">输入发票号:</span></div></td>
<td width="22%"><input name="acct_id" type="text" id="acct_id" /></td>
<td width="5%"> </td>
<td width="8%" class="STYLE2">营业区:</td>
<td width="20%"><select name="region_name" id="region_name">
<option selected="selected">1公司</option>
<option>2公司</option>
<option>3公司</option>
<option>4公司</option>
<option>5公司</option>
<option>8公司</option>
<option>6公司</option>
<option>公司</option>
<option>7公司</option>
<option>9公司</option>
</select>
</td>
<td width="8%"><input type="submit" name="Submit" value="提交" /></td>
<td width="18%"> </td>
</tr>
</table>
</form>
<form id="form3" name="form3" method="post" action="">
<table width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="6%" bgcolor="#FFFFFF"> </td>
<td width="9%" bgcolor="#FFFFFF"> </td>
<td width="22%" bgcolor="#FFFFFF"> </td>
<td width="3%" bgcolor="#FFFFFF"> </td>
<td width="10%" bgcolor="#FFFFFF"> </td>
<td width="23%" bgcolor="#FFFFFF"> </td>
<td width="5%" bgcolor="#FFFFFF"> </td>
<td width="22%" bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF" class="STYLE2">营业区:</td>
<td bgcolor="#FFFFFF"><input name="region_name" type="text" id="region_name" value="<%"MM_Region_Name"%>" /></td>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF" class="STYLE2">用户名:</td>
<td bgcolor="#FFFFFF"><input name="user_name" type="text" id="user_name" value="<%"MM_User_Name"%>" /></td>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF" class="STYLE2">电话号码:</td>
<td bgcolor="#FFFFFF"><input name="user_nbr" type="text" id="user_nbr" value="<%"MM_User_Nbr"%>" /></td>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF" class="STYLE2">押金类型:</td>
<td bgcolor="#FFFFFF"><input name="deposit_type" type="text" id="deposit_type" value="<%"MM_Deposit_Type"%>" /></td>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF" class="STYLE2">收款时间:</td>
<td bgcolor="#FFFFFF"><input name="rescv_time" type="text" id="rescv_time" value="<%"MM_Rescv_Time"%>" /></td>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF" class="STYLE2">金额:</td>
<td bgcolor="#FFFFFF"><input name="charge" type="text" id="charge" value="<%"MM_Charge"%>" /></td>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF" class="STYLE2">发票号:</td>
<td bgcolor="#FFFFFF"><input name="acct_id" type="text" id="acct_id" value="<%"MM_Acct_Id"%>" /></td>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF" class="STYLE2">发票类型:</td>
<td bgcolor="#FFFFFF"><input name="acct_type" type="text" id="acct_type" value="<%"MM_Acct_Type"%>" /></td>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"> </td>
</tr>
</table>
</form>
</body>
</html>
<%
Recordset1.Close();
%>
为什么查询后不显示结果?我的空结果集判断和变量用的是不是有问题?