请教:sqlserver中的分页问题。
数据库是sqlserver2000
程序如下,每执行到最后一句rs.AbsolutePage = int(curpage)时,就会出错。
<%
if len(request.QueryString("page")) = 0 then
curpage = 1
else
curpage = trim(request.QueryString("page"))
end if
strsql = "select * from tab_cooperation_resource where org_org_name = '"& org_name &"' and org_res_catalog = '"& request.QueryString("type") &"' order by org_res_time desc"
set rs = server.CreateObject("adodb.recordset")
rs.open strsql,conn,1,1
rs.pagesize = 2
pagescount = rs.pagecount
i = 1
rs.AbsolutePage = cint(curpage)
%>