瑜伽半神猴式动作详解:错误类型：ADODB.Recordset (0x800A0BB9)参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突。

<!--#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")
sql = "select * form teacher where password='"&password&"'"
rs.open sql,conn,1,1
if rs(0) > 0 then
rs.close
set rs = nothing
conn.close
set conn = nothing
response.write "<script>alert('该登录名已经有人使用了');history.go(-1);</script>"
response.end
end if
rs.close

sql = "select * from teacher where teacherid is null"
set rs = server.createobject("adodb.recordset")
rs.open sql,conn,1,3
if (rs.bof and rs.eof) then
rs.addnew
rs("teachernumber")=teachernumber
rs("teachername")=teachername
rs("password")=password
rs("phonenumber")=phonenumber
rs.update
rs.close
set rs = nothing
conn.close
set conn = nothing
end if
response.write "<script>alert('添加成功');;</script>"
%>

请教各位高手帮忙看下，到底是什么问题。浏览器报错在第27行 rs.open sql,conn,1,1