错误类型：ADODB.Recordset (0x800A0BB9)参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突。

来源：百度知道 编辑：UC知道 时间：2024/05/17 23:55:49
<!--#include file="conn.asp"-->
<%
dim sql
dim rs
dim teachername
dim teachernumber
dim phonenumber
teachernumber = request("teachernumber")
teachername = trim(request("teachername"))
password = request("password")
password1= request("password1")
phonenumber=request("phonenumber")
if teachername = "" then
response.write "<script>alert('请输入教师姓名');history.go(-1);</script>"
response.end
end if
if teachernumber = "" then
response.write "<script>alert('请输入教师工号');history.go(-1);</script>"
response.end
end if
if password<>password1 then
response.write "<script>alert('请重新输入密码');history.go(-1);</script>"
response.end
end if
set rs = server.createobject("adodb.recordset")
sq

sql = "select * form teacher where password='"&password&"'"
rs.open sql,conn,1,1
if rs.recordCount> 0 then 'if not rs.eof or not rs.bof
response.write "<script>alert('该登录名已经有人使用了');history.go(-1);</script>"

response.end
rs.close

'conn.close ''''''''不要关闭连接
'set conn = nothing
end if

rs.close
set rs = nothing