感谢斑竹和各位高手对小弟的帮助,以下问题希望得到解决
错误提示:
ADODB.Recordset 错误 '800a0bb9'
变量或者类型不正确,或者不在可以接受的范围之内,要不就是与其他数据冲突。
/Car_Search.asp,行33
错误代码显示如下:
<%
dim sql,str,memberPrice,rs,fa_class
dim pages,records,currentpage,linenumber,line,p
fa_class=request("fa_class")
Set rs = Server.CreateObject("ADODB.Recordset")
if fa_class="按汽车类型搜索" then
sql="select * from product order by id desc"
else if fa_class="轿车类" then
sql="select * from product where fa_class like '%轿车类%'"
else if fa_class="客车类" then
sql="select * from product where fa_class like '%客车类%'"
else if fa_class="货车类" then
sql="select * from product where fa_class like '%货车类%'"
else if fa_class="面包车类" then
sql="select * from product where fa_class like '%面包车类%'"
else if fa_class="越野车类" then
sql="select * from product where fa_class like '%越野车类%'"
end if
end if
end if
end if
end if
end if
rs.open sql,conn,3,2 '这就是错误的地方
if rs.eof and rs.bof then str="目前没有您需要的汽车类型,请重新搜索!"
'分页设置
if str="" then
rs.PageSize=10
pages=rs.pagecount
records=rs.recordcount
currentpage=request("currentpage")
if currentpage="" or currentpage<1 then currentpage=1
currentpage=cint(currentpage)
if currentpage>pages then currentpage=pages
rs.absolutepage=currentpage
else
currentpage=1
records=0
pages=1
end if
%>
[此贴子已经被作者于2005-11-25 14:14:32编辑过]