标题:
ASP Access 中 前后移动记录集的当前位置 By Stabx
正文:
QUOTE:
ASP Access 中 前后移动记录集的当前位置 By Stabx
shawl.qiu
2006-6-1
CODE:
<%'ASP Access 中 前后移动记录集的当前位置
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from ctarticle",MM_conn_String,1 '游标设置决定可否前后移动记录集
'设置参数: recordset.Open Source, ActiveConnection, CursorType, LockType, Options
rs.movelast '移至查询的最后一条记录
response.Write rs("articleid")
response.write " "
response.write rs("title")
response.write "<p/>"
rs.moveprevious '移至当前记录的前一条记录
response.Write rs("articleid")
response.write " "
response.write rs("title")
response.write "<p/>"
rs.move -10 '移至当前记录的第前十条, 当然可以用 +# 来移动记录集
response.Write rs("articleid")
response.write " "
response.Write rs("title")
response.write "<p/>"
rs.movenext '移至当前记录的下一条
response.Write rs("articleid")
response.write " "
response.Write rs("title")
response.write "<p/>"
rs.movefirst '移至查询的第一条记录
response.Write rs("articleid")
response.write " "
response.Write rs("title")
response.write "<p/>"
rs.close
set rs=nothing
%>
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from ctarticle",MM_conn_String,1 '游标设置决定可否前后移动记录集
'设置参数: recordset.Open Source, ActiveConnection, CursorType, LockType, Options
rs.movelast '移至查询的最后一条记录
response.Write rs("articleid")
response.write " "
response.write rs("title")
response.write "<p/>"
rs.moveprevious '移至当前记录的前一条记录
response.Write rs("articleid")
response.write " "
response.write rs("title")
response.write "<p/>"
rs.move -10 '移至当前记录的第前十条, 当然可以用 +# 来移动记录集
response.Write rs("articleid")
response.write " "
response.Write rs("title")
response.write "<p/>"
rs.movenext '移至当前记录的下一条
response.Write rs("articleid")
response.write " "
response.Write rs("title")
response.write "<p/>"
rs.movefirst '移至查询的第一条记录
response.Write rs("articleid")
response.write " "
response.Write rs("title")
response.write "<p/>"
rs.close
set rs=nothing
%>