<%
rs.open "SELECT * FROM hnhrdata..gzrz where convert(varchar(10),nowtime,120)=convert(varchar(10),getdate(),120)"
if rs.eof then
rs.open "SELECT * FROM hnhrdata..gzrz where convert(varchar(10),nowtime,120)=convert(varchar(10),getdate()-1,120)"
end if
%><%do while not rs.eof%>
<% rs.MoveNext
Loop
%>