ASP数据库条件查询

来源：百度知道 编辑：UC知道 时间：2024/07/05 23:36:32
<!--#include file="../com.asp"-->
<!--#include file="../info.asp"-->
if request("n")<>"" then
sl=request(trim("sname"))
set rs = server.CreateObject("adodb.recordset")
if request(trim("tl"))="daima" then
sql="select * from H_yesterday where daima='"&sl&"'"
end if
if request(trim("tl"))="gpm" then
sql="select * from H_yesterday where gpm='"&sl&"'"
end if
if request(trim("tl"))="times" then
sql="select * from H_yesterday where tims='"&sl&"'"
end if

rs.PageSize = 26 '这里设定每页显示的记录数
rs.CursorLocation = 3

rs.Open sql,conn,1,1'这120行

这家伙报ADODB.Recordset '800a0bb9'
参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突。

\h\search1.asp, line 120
错误
字段

<%
<!--#include file="../com.asp"-->
<!--#include file="../info.asp"-->
if request("n")<>"" then
sl=request("sname")
set rs = server.CreateObject("adodb.recordset")
dim tl
if sl="" then
response.Write("注意!你的变量sl是空值 sql语句会报错!")
response.End()
end if
tl=request(trim("tl"))
select case tl
case "daima"
sql="select * from H_yesterday where daima='"&sl&"'"
case "gpm"
sql="select * from H_yesterday where gpm='"&sl&"'"
case "times"
sql="select * from H_yesterday where tims='"&sl&"'"
case else
sql="select * from H_yesterday where tims='"&sl&"'"
end select

rs.PageSize = 26 '这里设定每页显示的记录数
rs.CursorLocation = 3