程序如下,我的库里明明有该月份的纪录,为何显示为空啊?!
accepttime为短日期格式,请高手救急,我的积分没了,不能悬赏了,请大家帮帮忙!
<%set rs=server.createobject("adodb.recordset")
rs.open "select id,casename,xyrname,xyrsex,casenature,sendaccusation,accepttime from aboutcase where accepttime between #2006-6-1# and #2006-12-30#", conn
if not rs.eof then
%>
……
<%if rs.eof then
response.write ("<script>alert('记录为空');location.href('select.htm')</script>")
end if
set rs=nothing
<% end if%>
參考答案:rs.open "select id,casename,xyrname,xyrsex,casenature,sendaccusation,accepttime from aboutcase where accepttime between #2006-6-1# and #2006-12-30#", conn ,1,1
你的记录集都没打开
也采用下面这个,效率比较低点
先把全部数据select出来,然后循环判断是不是在这时间范围内