|
<%
sql="select top 10 * from News where checked=true and smallclassname='新闻要闻' and bigclassname='新闻要闻' order by updatetime DESC"
rs.Open sql,conn,1,1
n=0
if not rs.eof then
while not rs.eof
n=n+1
%>"><%=rs("title")%> <%=year(rs("updatetime"))%>-<%=month(rs("updatetime"))%>-<%=day(rs("updatetime"))%>
"><%Response.Write left(HtmlSelfEnCodeWH(RS("Content"),rs("image"),150,95),220)%>......
<%
rs.movenext
wend
end if
rs.close
%>
|
