|
<%
n = 6
order = "ti"
desc = 1
sql="select * from news where cla=1"
IF order="ti" Then
sql=sql+" order by time"
ElSEIF order="ck" Then
sql=sql+" order by hotclick"
Else
sql=sql+" order by id"
End if
IF desc=1 Then sql=sql+" desc"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
IF Not rs.eof Then
proCount=rs.recordcount
rs.pagesize=cint(n)
if not IsEmpty(Request("topage")) and IsNumeric(Request("topage")) then
ToPage=CInt(Request("topage"))
if ToPage>rs.PageCount then
rs.AbsolutePage=rs.PageCount
intCurPage=rs.PageCount
elseif ToPage<=0 then
rs.AbsolutePage=1
intCurPage=1
else
rs.AbsolutePage=ToPage
intCurPage=ToPage
end if
else
rs.AbsolutePage=1
intCurPage=1
end if
intCurPage=CInt(intCurPage)
For i = 1 to rs.PageSize
if rs.EOF then
Exit For
end if
%>
<%
rs.MoveNext
Next
end if%>
<%
rs.close
set rs=nothing%>
|
|
<%
n = 6
order = "ti"
desc = 1
sql="select * from news where cla=5"
IF order="ti" Then
sql=sql+" order by time"
ElSEIF order="ck" Then
sql=sql+" order by hotclick"
Else
sql=sql+" order by id"
End if
IF desc=1 Then sql=sql+" desc"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
IF Not rs.eof Then
proCount=rs.recordcount
rs.pagesize=cint(n)
if not IsEmpty(Request("topage")) and IsNumeric(Request("topage")) then
ToPage=CInt(Request("topage"))
if ToPage>rs.PageCount then
rs.AbsolutePage=rs.PageCount
intCurPage=rs.PageCount
elseif ToPage<=0 then
rs.AbsolutePage=1
intCurPage=1
else
rs.AbsolutePage=ToPage
intCurPage=ToPage
end if
else
rs.AbsolutePage=1
intCurPage=1
end if
intCurPage=CInt(intCurPage)
For i = 1 to rs.PageSize
if rs.EOF then
Exit For
end if
%>
<%
rs.MoveNext
Next
end if%>
<%
rs.close
set rs=nothing%>
|
|
|