简单问题，大家来讨论

[zhlj2003]

我想取的表中某一特定纪录的下一条怎么做啊？
比如id=2的下一条纪录，id不是递增的

[cqfeng]

rs.movenext

[zhljsdly]

<%
set stu=server.createobject("adodb.recordset")
stu_sql="select stu_id from stu"
stu.open stu_sql,conn,1,3

for i=1 to stu.recordcount
if (stu("stu_id")<>stu_id) then stu.movenext end if
if (stu("stu_id")=stu_id) then
stu.movenext
stu_id=stu("stu_id")
end if
stu.movenext
next
%>