<%
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.open "Driver={SQL Server};Server=SERVER08;UID=user_web;PWD=724;Database=bookzone"
Set rs=Server.CreateObject("ADODB.RecordSet")
SQL="Select * from event_usrdata where event='115' order by ser desc"
rs.open SQL,conn,3,3
rs.PageSize=5
cPage=1
if Not rs.eof then
if not isTrulyNumeric(Trim(request("pg"))) then
cpage=1
else
cpage=Trim(Request("pg"))
end if
if cint(cpage)<1 then
cpage=1
end if
if cint(cpage)>rs.Pagecount then
cpage=rs.pagecount
end if
rs.AbsolutePage=cPage
i=1
bgcolor_str = ""
record_count = rs.recordcount
ii = record_count - (cpage - 1) * 5
Do while Not rs.eof and i<=rs.PageSize
%>
目前串連人數:
<%
Set rs1=Server.CreateObject("ADODB.RecordSet")
SQL="Select count(*) as num from event_usrdata where event='115'"
rs1.open SQL,conn,3,3
response.write(rs1("num"))
rs1.close
%>
頁數<%=cint(cpage)%>/<%=rs.pagecount%>
<% if cint(cpage)< rs.pagecount then %>下一頁<% end if %>
<% end if %>
<%
rs.close
set rs = nothing
conn.close
%>