28,409
社区成员




keywords=split(RsArticle1("guanjian")," ")
keysnext=""
for i=0 to ubound(keywords)
if keywords(i)<>"" and not isnull(keywords(i)) then
if i=0 then
keysnext=keysnext&" and (guanjian like '%"&keywords(i)&"%'"
else
keysnext=keysnext&" or guanjian like '%"&keywords(i)&"%'"
end if
keysnext=keysnext&")"
end if
next
set rs=server.createobject("adodb.recordset")
sql="Select * from Article where anclassid<>29 and anclassid<>38 "&keysnext&" order by UpdateTime DESC"
rs.open sql,conn,1,1
if not rs.eof then
If not Rs.Eof Then
Call PageSet(Rs ,10)
end if
i=0
Do while ((not Rs.eof) and (i < Rs.PageSize)) %>
Sub PageSet( RsArticle ,Num)
RsArticle.PageSize = Num '每页显示记录数
If Not IsEmpty(page) Then '如果page已经初始化...
If Not IsNumeric(page) Then '判断page值是否为数字
page=1
Else
Page = cint(page) '接收page并化为数字型赋给page变量
End If
If Page > RsArticle.PageCount Then '如果接收的页数大于总页数
RsArticle.AbsolutePage = RsArticle.PageCount '设置当前显示页等于最后页
Elseif Page <= 0 Then '如果page小于等于0
RsArticle.AbsolutePage = 1 '设置当前显示页等于第一页
Else
RsArticle.AbsolutePage = Page '如果大于零,显示当前页等于接收的页数
End if
Else
RsArticle.AbsolutePage=1
End if
Page = RsArticle.AbsolutePage
End Sub
'------------------------------------------------------
Sub PageNext( RsArticle ,Page )
filepath = "zhuanti.asp?key="&key&"&zuozhe="&zuozhe&"&guanjian="&guanjian
end sub