UC知道asp 搜索时间范围内的数据
来源：百度知道 编辑：UC知道 时间：2024/07/01 01:02:51
ADODB.Recordset 错误 '800a0bb9'
代码如下：
<%
Dim year,Time1,card
year=Trim(request("year"))
time1=Trim(request("time"))
card=session("card")
Set rs=server.CreateObject("adodb.recordset")
Select Case time1
Case "1"
sql="select distinct top 1 * from down200703 where card='"&session("card")&"' and year='"&year&"' and Time BETWEEN '07:00' AND '16:47'"
Case "2"
sql="select distinct top 1 * from down200703 where card='"&session("card")&"' and year='"&year&"' and Time BETWEEN '11:30' AND '13:00'"
Case "3"
sql="select distinct top 1 * from down200703 where card='"&session("card")&"' and year='"&year&"' and Time BETWEEN '13:30' AND '14:
代码如下：
<%
Dim year,Time1,card
year=Trim(request("year"))
time1=Trim(request("time"))
card=session("card")
Set rs=server.CreateObject("adodb.recordset")
Select Case time1
Case "1"
sql="select distinct top 1 * from down200703 where card='"&session("card")&"' and year='"&year&"' and Time BETWEEN '07:00' AND '16:47'"
Case "2"
sql="select distinct top 1 * from down200703 where card='"&session("card")&"' and year='"&year&"' and Time BETWEEN '11:30' AND '13:00'"
Case "3"
sql="select distinct top 1 * from down200703 where card='"&session("card")&"' and year='"&year&"' and Time BETWEEN '13:30' AND '14:
错误发生在“Time BETWEEN ”段，应该是
time >='13:30' and time <='14:00'
BETWEEN在数据库中只能查询数值类型，对字符类型会出错
rs.open sql,conn,3,2 （错误行） 因为错误的sql语句所以出错了
根据你的补充，问题肯定是出在between上