asp+aceese编程问题

来源：百度知道 编辑：UC知道 时间：2024/06/04 23:36:36
<%sql="select*from config set rs=server.creatoject("adodb.recordset") rs.open sql,conn,1,1 school=rs("school") department =rs("department") rs.close set rs=nothing%>错误类型ADODB.Recordset (0x800A0BB9)参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突

<%
sql="select*from config"
set rs=server.creatoject("adodb.recordset")
rs.open sql,conn,1,1
school=rs("school")
department=rs("department")
rs.close
set rs=nothing
%>

<%
set rs=server.creatoject("adodb.recordset")
sql="select * from config "
rs.open sql,conn,1,1
school=rs("school")
department =rs("department")
rs.close
set rs=nothing
%>
在sql="Select * from config" 这里少了一个"