<%
if request("order")="" then
order="id"
else
order=request("order")
end if
if request("showlist")="" then
showlist="desc"
else
showlist=request("showlist")
end if
dim rs
dim sql
select case request("showwhat")
case "showpic"
msg_per_page = 8 '¶¨ÒåÿҳÏÔʾ¼Ç¼ÌõÊý
case "shownonepic"
msg_per_page = 12
case "showbylist"
msg_per_page = 20
case else
msg_per_page = 8
end select
set rs = server.createobject("adodb.recordset")
%>
<%if request("typeid")="" then%>
<%sql = "select * from ceocio order by "&order&" "&showlist&""%>
<%else%>
<%typeid=request("typeid")%>
<%sql = "select * from ceocio where typeid='"&typeid&"' order by "&order&" "&showlist&""%>
<%end if%>
<%rs.cursorlocation = 3 'ʹÓÿͻ§¶ËÓα꣬¿ÉÒÔʹЧÂÊÌá¸ß
rs.pagesize = msg_per_page '¶¨Òå·ÖÒ³¼Ç¼¼¯Ã¿Ò³ÏÔʾ¼Ç¼Êý
rs.open sql,conn,0,1
if err.number<>0 then '´íÎó´¦Àí
response.write "Êý¾Ý¿â²Ù×÷ʧ°Ü£º" & err.description
err.clear
else
if not (rs.eof and rs.bof) then '¼ì²â¼Ç¼¼¯ÊÇ·ñΪ¿Õ
totalrec = RS.RecordCount 'totalrec£º×ܼǼÌõÊý
if rs.recordcount mod msg_per_page = 0 then '¼ÆËã×ÜÒ³Êý,recordcount:Êý¾ÝµÄ×ܼǼÊý
n = rs.recordcount\msg_per_page 'n:×ÜÒ³Êý
else
n = rs.recordcount\msg_per_page+1
end if
currentpage = request("page") 'currentpage:µ±Ç°Ò³
If currentpage <> "" then
currentpage = cint(currentpage)
if currentpage < 1 then
currentpage = 1
end if
if err.number <> 0 then
err.clear
currentpage = 1
end if
else
currentpage = 1
End if
if currentpage*msg_per_page > totalrec and not((currentpage-1)*msg_per_page < totalrec)then
currentPage=1
end if
n=1
do while not rs.eof and n<=rs.pageSize
if n mod 3 = 1 then response.write "<tr>"
response.write "<Td>"
response.write "这里输出出错"
response.write "</td>"
if n mod 3 = 0 then response.write "</tr>"
n=n+1
rs.movenext
loop
rs.absolutepage = currentpage 'absolutepage£ºÉèÖÃÖ¸ÕëÖ¸Ïòijҳ¿ªÍ·
rowcount = rs.pagesize 'pagesize£ºÉèÖÃÿһҳµÄÊý¾Ý¼Ç¼Êý
dim i
dim k%>
<%
do while not rs.eof and rowcount>0
%>