%'if Request.QueryString("no")="eshop" then
'dim SQL, Rs, contentID,CurrentPage
'CurrentPage = request("Page")
'contentID=request("ID")
'set rs=server.createobject("adodb.recordset")
'sqltext="delete from job where Id="& contentID
'rs.open sqltext,conn,3,3
'set rs=nothing
'conn.close
'response.redirect "Manage_Job.asp"
'end if
%>
<%
set rs=server.createobject("adodb.recordset")
sqltext="select * from job order by id desc"
rs.open sqltext,conn,1,1
dim MaPerPage
MaPerPage=2
dim text,checkpage
text="0123456789"
Rs.PageSize=MaPerPage
for i=1 to len(request("page"))
checkpage=instr(1,text,mid(request("page"),i,1))
if checkpage=0 then
exit for
end if
next
If checkpage<>0 then
If NOT IsEmpty(request("page")) Then
CurrentPage=Cint(request("page"))
If CurrentPage < 1 Then CurrentPage = 1
If CurrentPage > Rs.PageCount Then CurrentPage = Rs.PageCount
Else
CurrentPage= 1
End If
If not Rs.eof Then Rs.AbsolutePage = CurrentPage end if
Else
CurrentPage=1
End if
call showpages
call list
If Rs.recordcount > MaPerPage then
call showpages
end if
'显示帖子的子程序
Sub list()%>