<%
page=clng(request("page"))
Set rs=Server.CreateObject("ADODB.RecordSet")
if BigClass<>"" and SmallClass <>"" then
sql="select * from news where BigClassName='"&BigClass&"' and SmallClassName='"&SmallClass&"' order by AddDate desc"
rs.Open sql,conn,1,1
elseif BigClass<>"" then
sql="select * from news where BigClassName='"&BigClass&"' order by AddDate desc"
rs.Open sql,conn,1,1
end if
if rs.eof and rs.bof then
response.Write("暫時(shí)沒有記錄")
else
%>
<%
rs.PageSize=20
if page=0 then page=1
pages=rs.pagecount
if page > pages then page=pages
rs.AbsolutePage=page
for j=1 to rs.PageSize
%>
 |
" target="_blank" style="text-decoration:none; color:#1d5aa6;"> <%= RS("TITLE") %> |
[<%=FormatDateTime(RS("AddDate"),2)%>] |
<%
rs.movenext
if rs.eof then exit for
next
%>
<%if rs.pagesize>20 then%>
<%end if%> |
<%
end if
rs.close
set rs=nothing
%>
|