登录出现问题:至少一个参数没有被指定值。
请大家帮我看看,出现这个问题究竟错在哪儿呀?谢谢!错误类型:
Microsoft JET Database Engine (0x80040E10)
至少一个参数没有被指定值。
/tep/ws-jpd-pz/pz1/pz/login.asp, 第 14 行
login.asp
<!--#include file="ainsi/conn.asp" -->
<%
If Request("Action") = "post" Then
UserName3 = Request("UserName3")
UserPass = Request("UserPass")
Code = UCase(Trim(Request("Code")))
If Code = "" Or Code <> Session("Code") Then
Response.Write "<script>alert('请输入正确的验证码!');history.go(-1);</script>"
Else
Set Rs=Server.CreateObject("Adodb.RecordSet")
第14行。。。Rs.Open "Select * From dlnimda Where UserName3='"&UserName3&"' And UserPass='"&UserPass&"'",conn,1,1.................................第14行 If Not(Rs.Bof Or Rs.Eof) Then
Session("UserName3") = Trim(Rs("UserName3"))
Response.Redirect "cgdl.asp"
Else
Response.Write "<script language='javascript'>alert('登录失败,请检查用户名和密码!');location.replace('login.asp')</script>"
End If
Rs.Close
Set Rs = Nothing
End If
End If
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.
<html xmlns="http://www.
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>用户登录</title>
<style type="text/css">
*{margin:0; padding:0; font:12px/22px normal Arial; color:#666}
table{border-collapse:collapse}
table td{border:1px solid #ddd;border-collapse:collapse;line-height:30px;padding:0 5px}
table td span{color:#f00; margin-left:5px}
.input{border:1px solid #c5c6c4;width:180px;height:20px;line-height:20px}
.btn{border:1px solid #ddd;padding:0 8px;height:22px; margin-right:8px}
.msg{width:400px; height:100px; border:1px solid #c5c6c4}
</style>
<script language="javascript" type="text/javascript">
function Check(){
if(document.Login.UserName3.value==""){
alert("请输入用户名!");
document.Login.UserName3.focus();
return false;
}
if(document.Login.UserPass.value == ""){
alert("请输入密码!");
document.Login.UserPass.focus();
return false;
}
if (document.Login.Code.value==""){
alert ("请输入您的验证码!");
document.Login.Code.focus();
return false;
}
}
</script>
<link href="ys.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
body {
margin-top: 50px;
}
-->
</style></head>
<body>
<table cellpadding="0" cellspacing="0" width="350" align="center">
<form action="?Action=post" method="post" name="Login" id="Login" onsubmit="return Check();">
<tr>
<td height="30" colspan="2" align="center" bgcolor="#0099FF" class="ztb18"><strong class="ztb18"> 管 理 员 登 录</strong></td>
</tr>
<tr>
<td width="120" align="right" bgcolor="#F0FFFF">用户名:</td>
<td width="280" align="left" class="vs12"><input name="UserName3" type="text" class="bj14" id="UserName3" size="19" /></td>
</tr>
<tr>
<td align="right" bgcolor="#F0FFFF">密 码:</td>
<td align="left" class="vs12"><input name="UserPass" type="password" class="bj14" id="UserPass" size="20" /></td>
</tr>
<tr>
<td align="right" bgcolor="#F0FFFF">验证码:</td>
<td align="left" class="vs12"><input type="text" class="bj14" name="Code" id="Code" style="width:60px" />
<img src="ainsi/code.asp" style="cursor:pointer" onclick="this.src='ainsi/code.asp?'+Math.random()" />点击图片更换</td>
</tr>
<tr>
<td align="right"> </td>
<td><input name="submit" type="submit" class="btn" value="登录" />
<input name="reset" type="reset" class="btn" value="重置" /></td>
</tr>
</form>
</table>
<p> </p>
</body>
</html>
[ 本帖最后由 tepnidh 于 2009-8-19 09:31 编辑 ]