SQL SERVER 不支持AbsolutePage是怎么回事，怎么解决，请高手指教？

[swordsman2000]

<%
if not isempty(request("page")) and request("page")<>"" then
ipage=cint(request("page"))
else
ipage=1
end if
set rs1=server.createobject("ADODB.recordset")
sql1="select * from ...
rs1.open sql1,conn,3,2

if not rs1.eof then
Rs1.PageSize=1
Rs1.AbsolutePage=ipage
......

[whyy0]

rs1.open sql1,conn,1,3
要不就是
rs1.open sql1,conn,3,1
记不清楚了

[空闲独处]

RS.CursorLocation = 2
RS.CacheSize = iRowsPerPage '每页显示的记录数
RS.Open strSQL,Conn,3,1 ' adOpenStatic=3, adLockReadOnly=1

IF NOT RS.EOF Then
RS.PageSize = iRowsPerPage '每页显示的记录数
RS.AbsolutePage = iPageNum '当前页
Do While Not RS.EOF And (iLoop <= iRowsPerPage)
。。。
LOOP
END IF

[angelheavens]

rs1.open sql1,conn,1,1

[oneway888]

rs.open sql,conn,1,3