<%
Set rslist = Server.CreateObject("ADODB.Recordset")
sql="select BigClassID,BigClassName from okuoo_BigClass_New order by BigClassID"
rslist.open sql,conn,1,3
do while not rslist.eof
%>
<%rslist.movenext
loop
rslist.close
set rslist=nothing
%> |
|
|
<%
page=clng(request("page"))
Set rs=Server.CreateObject("ADODB.RecordSet")
if len(BigClass) >0 then
sql="select * from okuoo_news where BigClassName='"&BigClass&"' order by AddDate desc"
rs.Open sql,conn,1,1
else
sql="select * from okuoo_news order by AddDate 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 %>
"><%=rs("title")%> |
[<%=FormatDateTime(rs("AddDate"),2)%>] |
<%
rs.movenext
if rs.eof then exit for
next
%>
<%
end if
rs.close
set rs=nothing
%>
|
|
|
|