index_diary.asp

功能强大的一个b/s工作站

<%sub index_diary()
dim totaldiary,Currentpage,totalpages,i
opendiary
sql="select * from diary order by d_date DESC"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%> 
<table width="100%" border="0" cellspacing="0" align="center" cellpadding="4">
  <%if not rs.eof then
rs.Movefirst
rs.pagesize=diaryperpage
if trim(request("page"))<>"" then
    currentpage=clng(request("page"))
	if currentpage>rs.pagecount then
	   currentpage=rs.pagecount
	end if
else
    currentpage=1
end if
    totaldiary=rs.recordcount
	if currentpage<>1 then
	   if(currentpage-1)*diaryperpage<totaldiary then
	      rs.move(currentpage-1)*diaryperpage
		  dim bookmark
		  bookmark=rs.bookmark
	   end if
	end if
	if (totaldiary mod diaryperpage)=0 then
	   totalpages=totaldiary\diaryperpage
	else
	   totalpages=totaldiary\diaryperpage+1
	end if
i=0
do while not rs.eof and i<diaryperpage
url="showdiary.asp?id="&rs("d_id")%>
  <tr> 
    <td class="chinese" bgcolor="#FFFFFF" align="right">
<table width="100%" border="0" cellspacing="1" align="center">
        <tr> 
          <td class="chinese"><%=ubb2html(cutstr(formatStr(autourl(rs("d_content"))),700,true,url), true, true)%></td>
        </tr>
      </table>
      
    </td>
  </tr>
  <%
i=i+1
rs.movenext
loop
else
If rs.EOF And rs.BOF Then%>
  <tr> 
    <td height="30" class="chinese" align="center" bgcolor="#E7E3E7">目前还没有记录！</td>
  </tr>
  <%end if
end if%>
</table>
<%
rs.close
set rs=nothing
end sub%>