<%
newssql="select top 4 * from news where smallclassname='公司新闻' and show=true order by id desc"
set newsrs=conn.execute(newssql)
do while not newsrs.eof
infotime=newsrs("infotime")
if newsrs("daylimit")=0 or datediff("d",infotime,now())<=nrs("daylimit") then
%>
<%
end if
newsrs.movenext
loop
newsrs.close
set newsrs=nothing
%>
<%
tsql="select top 8 * from products where indexpic=true order by pro_id asc"
set trs=server.createobject("adodb.recordset")
trs.open tsql,conn,1,1
do while not trs.eof
%>