ASP按时间段查询句语

" />

>按金额排列
>按积分排列


开始日期
结束日期
可模糊查找会员信息




<%
Set Rs = Server.CreateObject("Adodb.Recordset")
dim txtsearch,orderlist
dim rs,sql
txtsearch=trim(request("txtsearch"))
orderlist=cint(request("orderlist"))

sql="select * from [sjmx] where (shangjia like '%"&txtsearch&"%' or kahao like '%"&txtsearch&"%' )"

if orderlist=1 then sql=sql & " order by jinge desc"
if orderlist=2 then sql=sql & " order by jifen desc"

if (orderlist<1) or (orderlist>2) then sql=sql & " order by id desc"
'sql=replace(sql,table2&" and",table2&" where")

Rs.Open Sql,Conn,1,1
%>

以上是查询的这一段代码。我现在是要添加按时间段查询，数据表中时间的格式 是
2013-9-8 13:37:20
上面的日期表出来的格式是 2013-09-08

***你自己改一下代码里的日期字段名***


<%
Set Rs = Server.CreateObject("Adodb.Recordset")
dim txtsearch,orderlist
dim rs,sql
txtsearch=trim(request("txtsearch"))
orderlist=cint(request("orderlist"))

sql="select * from [sjmx] where (shangjia like '%"&txtsearch&"%' or kahao like '%"&txtsearch&"%' )"

if orderlist=1 then sql=sql & " order by jinge desc"
if orderlist=2 then sql=sql & " order by jifen desc"
if orderlist=3 then sql=sql & " order by 日期字段名 desc"

if (orderlist<1) or (orderlist>3) then sql=sql & " order by id desc"
'sql=replace(sql,table2&" and",table2&" where")

Rs.Open Sql,Conn,1,1
%>

使用 between

set objrs = objconn.execute("select sum(htzj) from xinxi where shijian>=#'"&enabledate&"'# and shijian<=#'"&expiredate&"'#") 改成 set objrs = objconn.execute("select sum(htzj) as sl from xinxi where shijian between '"&enabledate&"' and '"&expiredate&"'") 问题补充：用现在方法,在日期为空时,就提示错误,有什么好的方法让起始时间和结束时间都为空时,能查询全部数据库里的资料.谢谢! sql="select sum(htzj) as sl from xinxi" if enabledate<>"" and expiredate<>"" then sql=sql&" where shijian between '"&enabledate&"' and '"&expiredate&"'" end if set objrs = objconn.execute(sql)

检查一下数据库类的时间字段类型是不是data类型还是datatime类型？datatime类型才是正确

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息