|
|
|
<%
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 id desc"
rs.Open sql,conn,1,1
elseif BigClass<>"" then
sql="select * from news where BigClassName='"&BigClass&"' order by id desc"
rs.Open sql,conn,1,1
end if
if rs.eof and rs.bof then
response.Write("暂时没有记录")
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
%>
|
<% if rs("FirstImageName")<>"" then response.write "" end if %>
" target="_blank"><%= RS("TITLE") %> |
[<%= RS("AddDate") %>] (点击<%= RS("hits") %>) |
<%
rs.movenext
if rs.eof then exit for
next
%>
|
<%
end if
rs.close
set rs=nothing
%>
|
|