set rs=server.createobject("adodb.recordset")
sql="select * from table "
rs.open sql,conn,1,1
i=0
do while not rs.eof and i<32
操作记录
i=i+1
rs.movenext
loop
mark=rs.bookmark
在这里你可以做别的事情
set rs=server.createobject("adodb.recordset")
sql="select * from table "
rs.open sql,conn,1,1
rs.bookmark=mark
继续向下对数据库操作!
<%
set rs=server.createobject("adodb.recordset")
sql="select * from sy_products "
rs.open sql,conn,1,1
i=0
do while not rs.eof and i<5
response.Write rs("pname")
i=i+1
rs.movenext
loop
mark=rs.bookmark
rs.close
set rs=nothing
set rs=server.createobject("adodb.recordset")
sql="select * from sy_products "
rs.open sql,conn,1,1
rs.bookmark=mark
do while not rs.eof
response.Write rs("pname")
rs.movenext
loop
rs.close
set rs=nothing