ADODB.Recordset (0x800A0BB9)参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突
IIS的服务器好麻烦本身就不太懂计算机这方面拜托哪位高手帮帮忙万分感谢~~错误类型:ADODB.Recordset(0x800A0BB9)参数类型不正确,或不在可以接受的...
IIS的服务器好麻烦 本身就不太懂计算机这方面 拜托哪位高手帮帮忙 万分感谢~~
错误类型:
ADODB.Recordset (0x800A0BB9)
参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。
/hngct/index.asp, 第 7 行
第 7 行是 “rs.Open sq9,strconn,1,3,8”
具体代码如下:
<%@LANGUAGE="VBSCRIPT" %>
<%
strconn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("admin/db.mdb")
set rs=Server.CreateObject("adodb.recordset")
sql="SELECT top 6 Id,Title,DATE FROM tbNews where jjtype='4' order by Id desc"
rs.Open sq9,strconn,1,3,8
set rs0=Server.CreateObject("adodb.recordset")
sql0="SELECT top 9 Id,Title,DATE FROM tbNews where jjtype='0' order by Id desc"
rs0.Open sql0,strconn,1,3,8
set rs1=Server.CreateObject("adodb.recordset")
sql1="SELECT top 12 Id,Title,DATE FROM tbNews where jjtype='5' order by Id desc"
rs1.Open sql1,strconn,1,3,8
set rs2=Server.CreateObject("adodb.recordset")
sql2="SELECT top 9 Id,Title,DATE FROM tbNews where jjtype='2' order by Id desc"
rs2.Open sql2,strconn,1,3,8
set rs3=Server.CreateObject("adodb.recordset")
sql3="SELECT top 9 Id,Title,DATE FROM tbNews where jjtype='3' order by Id desc"
rs3.Open sql3,strconn,1,3,8
set rs4=Server.CreateObject("adodb.recordset")
sql4="SELECT top 9 Id,Title,DATE,content FROM tbNews where jjtype='4' order by Id desc"
rs4.Open sql4,strconn,1,3,8
set rs5=Server.CreateObject("adodb.recordset")
sql5="SELECT top 8 Id,Title,DATE FROM tbNews where jjtype='5' order by Id desc"
rs5.Open sql5,strconn,1,3,8
set rs7=Server.CreateObject("adodb.recordset")
sql7="SELECT top 8 Id,Title,DATE FROM tbNews where jjtype='1' order by Id desc"
rs7.Open sql7,strconn,1,3,8
set rs8=Server.CreateObject("adodb.recordset")
sql8="SELECT top 8 Id,Title,DATE FROM tbNews where jjtype='6' order by Id desc"
rs8.Open sql8,strconn,1,3,8 展开
错误类型:
ADODB.Recordset (0x800A0BB9)
参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。
/hngct/index.asp, 第 7 行
第 7 行是 “rs.Open sq9,strconn,1,3,8”
具体代码如下:
<%@LANGUAGE="VBSCRIPT" %>
<%
strconn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("admin/db.mdb")
set rs=Server.CreateObject("adodb.recordset")
sql="SELECT top 6 Id,Title,DATE FROM tbNews where jjtype='4' order by Id desc"
rs.Open sq9,strconn,1,3,8
set rs0=Server.CreateObject("adodb.recordset")
sql0="SELECT top 9 Id,Title,DATE FROM tbNews where jjtype='0' order by Id desc"
rs0.Open sql0,strconn,1,3,8
set rs1=Server.CreateObject("adodb.recordset")
sql1="SELECT top 12 Id,Title,DATE FROM tbNews where jjtype='5' order by Id desc"
rs1.Open sql1,strconn,1,3,8
set rs2=Server.CreateObject("adodb.recordset")
sql2="SELECT top 9 Id,Title,DATE FROM tbNews where jjtype='2' order by Id desc"
rs2.Open sql2,strconn,1,3,8
set rs3=Server.CreateObject("adodb.recordset")
sql3="SELECT top 9 Id,Title,DATE FROM tbNews where jjtype='3' order by Id desc"
rs3.Open sql3,strconn,1,3,8
set rs4=Server.CreateObject("adodb.recordset")
sql4="SELECT top 9 Id,Title,DATE,content FROM tbNews where jjtype='4' order by Id desc"
rs4.Open sql4,strconn,1,3,8
set rs5=Server.CreateObject("adodb.recordset")
sql5="SELECT top 8 Id,Title,DATE FROM tbNews where jjtype='5' order by Id desc"
rs5.Open sql5,strconn,1,3,8
set rs7=Server.CreateObject("adodb.recordset")
sql7="SELECT top 8 Id,Title,DATE FROM tbNews where jjtype='1' order by Id desc"
rs7.Open sql7,strconn,1,3,8
set rs8=Server.CreateObject("adodb.recordset")
sql8="SELECT top 8 Id,Title,DATE FROM tbNews where jjtype='6' order by Id desc"
rs8.Open sql8,strconn,1,3,8 展开
2个回答
展开全部
有两处明显的错误:
1.未建立数据库连接;
2.rs的open方法错误;
可以参考以下代码:
<%
'建立数据库连接
set conn=server.createobject("adodb.connection")
strconn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("admin/db.mdb")
conn.open strconn
'建立rs记录集对象
set rs=Server.CreateObject("adodb.recordset")
sql="SELECT top 6 Id,Title,DATE FROM tbNews where jjtype='4' order by Id desc"
rs.Open sql,conn,1,3
'同样地,建立rs0记录集对象
set rs0=Server.CreateObject("adodb.recordset")
sql0="SELECT top 9 Id,Title,DATE FROM tbNews where jjtype='0' order by Id desc"
rs0.Open sql0,conn,1,3
'以此类推,rs1到rs8都按以上方法写代码
%>
1.未建立数据库连接;
2.rs的open方法错误;
可以参考以下代码:
<%
'建立数据库连接
set conn=server.createobject("adodb.connection")
strconn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("admin/db.mdb")
conn.open strconn
'建立rs记录集对象
set rs=Server.CreateObject("adodb.recordset")
sql="SELECT top 6 Id,Title,DATE FROM tbNews where jjtype='4' order by Id desc"
rs.Open sql,conn,1,3
'同样地,建立rs0记录集对象
set rs0=Server.CreateObject("adodb.recordset")
sql0="SELECT top 9 Id,Title,DATE FROM tbNews where jjtype='0' order by Id desc"
rs0.Open sql0,conn,1,3
'以此类推,rs1到rs8都按以上方法写代码
%>
本回答被提问者采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询