asp查询显示不出数据．请高手帮我看看下面的程序．急．谢谢

来源：百度知道编辑：UC知道时间：2024/05/25 07:34:12

on error resume next
dim id,setUser,setDate,needUser,carId
orderId=request("orderId")
setUser=request("setUser")
setDate=request("setDate")
needUser=request("needUser")
carId=request("carId")
rs.open"select * from orders where orderId like '%"&orderId&"%' and setUser like '%"&setUser&"%' and setDate like '%"&setDate&"%' and needUser like '%"&needUser&"%' and carId like '%"&carId&"%' order by id desc",conn,1,1

rs.pagesize=5
dim reqpage,pages,rows,records
records=rs.recordcount
rows=rs.pagesize
if records mod rows then
pages=fix(records/rows)+1
else
pages=fix(records/rows)
end if
reqpage=fix(request.QueryString("page"))
if reqpage<1 or (reqpage="") then
reqpage=1
end if
if pages &

初步看了下程序无错误建议你把sql语句放到sqlserver里测试下看看语法是否有错误
select * from orders where orderId like '% %' and setUser like '%%' and setDate like '%%' and needUser like '%%' and carId like '%%' order by id desc

carId=request("carId")
set rs=server.createobject("ADODB.Recordset")'检查一下,是否存在

asp查询显示不出数据．请高手帮我看看下面的程序．急．谢谢 asp数据查询问题 asp中数据查询 asp+access数据查询 ASP.NET数据查询 [高分]ASP 怎样只显示5条数据,高手请帮帮忙谢谢~! ASP不用数据库能否显示出任意条查询记录求 ASP查询数据库中显示查询出来的一行数据？？ asp程序为何显示不出结果 asp+access 时间段查询数据