pagesize=10
session("flag")=pagesize
set conn=server.createobject("ADODB.Connection")
conn.provider="microsoft.jet.oledb.4.0"
conn.open server.MapPath("#asp_net.mdb")
set session("rs")=server.createobject("ADODB.recordset")
session("rs").cuisorlocation=aduseclient
sql="select * from Tabnorm where astate='"& astate &"' and (sdate between #"&date1&"# and # "&date2&"#) order by ftime desc"
session("rs").open sql,conn,adopenstatic,adlockreadonly,adcmdtext
if session("rs").eof then
response.Write("<font color=red>没有查询的异常情况!</font>")
else
session("rs").pagesize=pagesize
for j=0 to session("rs").pagesize-1
response.Write "<div id=mydiv style=width:600px;height:4px><font color=red size=2>上报日期:</font>"&session("rs").fields(0).value&"</div>"
response.Write "<hr>"
response.Write "<div id=mydiv style=width:600px;height:4px><font color=red size=2>填表人:</font>"&session("rs").fields(1).value&"</div>"
response.Write "<hr>"
session("rs").movenext
if session("rs").eof then
exit for
end if
next
end if
%>
<!--#include file=abnormiclink1.asp-->
数据库中有这样的记录,可是怎么也查询不到。