急!!ADODB.Recordset 错误 '800a0bb9'
请高手帮忙解决!
ADODB.Recordset 错误 '800a0bb9'
参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。
/repairing/Top.asp,行 54
代码如下:
top.asp
<html>
<head>
<title>设备报修管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<SCRIPT language=javascript>
function save_onclick()
{
var strTemp = document.forms.MemCode.value;
if (strTemp.length == "" )
{
alert("请输入用户名!");
document.forms.MemCode.focus();
return false;
}
var strTemp = document.forms.password.value;
if (strTemp.length == "" )
{
alert("请输入密码!");
document.forms.password.focus();
return false;
}
}
</SCRIPT>
</head>
<BODY topmargin=0 leftmargin=0 rightmargin=0 bottommargin=0>
<table width="760" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><img src="images/top.gif" width="760" height="100"></td>
</tr>
</table>
<table width="760" border="0" cellspacing="0" cellpadding="0" align="center" class="table_southidc">
<tr>
<td height="24" width="1%" align="center"></td>
<td width="30%">
<font color="#000000"><b>
<script language="JavaScript" src="js/date.js" type="text/javascript"></script><script>document.write(+nian)</script>年<script>document.write(+yue)</script>月
<script>document.write(+ri)</script>日 星期<script>document.write(""+week)</script></b></font>
</td>
<td height="25" align="right"><strong>
<a href="Member_Reg.asp"><font color="#000000">用户注册</font></a><font color="#000000"> | <a href="index.asp" ><font color="000000">报修列表</font></a> | </font><a href="Repair.asp" ><font color="#000000">报修登记</font></a><font color="000000"> | <a href="Member_Loginsb.asp"><font color="0000000">注销登录</font></a></font></strong> </td>
<td width="1%" align="right"> </td>
</tr>
</table>
<table width="760" border="1" align="center" cellpadding="5" cellspacing="1" class="td_southidc">
<tr class=>
<td bgcolor="#FFFFFF"><table border=0 cellpadding=0 cellspacing=0 rules=cols width="100%" align="center" height="25">
<tr bgcolor="#FFFFFF">
<td height="25" ><span><strong>
<%if session("MemCode")<>"" then%>
<%
set rs_user=server.createobject("adodb.recordset")
sql="select * from Member where MemCode='"&session("MemCode")&"'"
rs_user.open sql,conn,3,2
%>
<%if rs_user("purview")=1 then%>管理员<%else%>报修用户<%end if%><%=session("MemCode")%>
<%response.write":您好,请把你要申报内容填写清楚!"
else
%>
</strong></span>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<form method="post" action="Member_login.asp" name="forms" onSubmit="return save_onclick()">
<tr>
<td align="left">
用户名:
<input name="MemCode" id="MemCode" style="font-size: 9pt; background-color:#CDF0F9" size="10" font face="宋体">
密码:
<input name="password" type="password" id="password" style="font-size: 9pt; background-color:#CDF0F9" size="10" font face="宋体">
<input name="Submit" type="submit" value="登陆">
<input name="Submit" type="reset" value="重置">
</td>
</tr>
</form>
</table>
<%end if%>
</td>
<td class=content9 bgcolor="#FFFFFF" height="25"><p align="right"><a href="Repair.asp" style="text-decoration: none" >报修申请>>></a></td>
</tr>
</table></td>
</tr>
</table>