<%

dim page,maxPerPage
maxPerPage=2

page=Request("page")
if (page="" or isempty(page)) then page=1

thisUrl="pring_gongzi.asp?yue='"&request("nianfen")+request("yuefen")

set rs=server.createobject("adodb.recordset")
rs.open "select * from  gongzi  where  yue='"&request("nianfen")+request("yuefen")&"'  order by id desc ",conn,1,1

rs.pagesize=MaxPerPage
%>


请教大家 红色的代码应该怎样改好呢,

感謝老大提供了思路,,,,,我把年份和月份分开了两个字段采用上面的方法解决了

<%
dim page,maxPerPage
maxPerPage=2
page=Request("page")
if (page="" or isempty(page)) then page=1
thisUrl="pring_gongzi.asp?nianfen=" & request("nianfen") & "&yuefen=" & request("yuefen")
set rs=server.createobject("adodb.recordset")
rs.open "select * from  gongzi  where  nianfen='"&request("nianfen")&"' and yuefen='"&request("yuefen")&"' order by id desc ",conn,1,1
rs.pagesize=MaxPerPage
%>