asp中的意外问题

来源:百度知道 编辑:UC知道 时间:2024/05/04 07:11:39
<!--#include file="conn1.asp"-->
<html>
<head>
</head>
<body>
<form name=log method=post action="">
登录<input type="text" name="login" size=10 id="name"><br>
密码<input type="text" name="pwd" size=10 id="pwd">
<input type=submit value=login name=log>
</form>
<%
dim rs
set rs=server.createobject("Adodb.recordset")
rs.Open "select * from [user] where [name]='"&request("login")&"'",conn
if rs.fields("name")=request.form("login") and rs.fields("password")=request.form("pwd")then
response.write "right"
else
response.write "wrong!"
end if
%>
</body>
</html>
错误类型:
(0x80020009)
发生意外。
/asp/login.asp, 第 1

改为
<!--#include file="conn1.asp"-->
<html>
<head>
</head>
<body>
<form name=log method=post action="">
登录<input type="text" name="login" size=10 id="login"><br>
密码<input type="text" name="pwd" size=10 id="pwd">
<input type=submit value=login name=log>
</form>
<%
dim rs
set rs=server.createobject("Adodb.recordset")
rs.Open "select * from [user] where [name]='"&request("login")&"'",conn,1,3
if rs("name")=request.form("login") and rs("password")=request.form("pwd") then
response.write "right"
else
response.write "wrong!"
end if
%>
</body>
</html>