Question

ASP如何在同一循环纪录中，显示上一条纪录和下一条纪录。

<% set rsa=server.createobject("adodb.recordset")
sqla="select * from LiouCheng where OT_ID="&rs("ID")&" order by ID desc"
rsa.open sqla,conn,1,1
if rsa.eof then
rsponse.write"暂无数据"
else
do while not rsa.eof

显示后一条 rsa("czy") 显示前一条

rsa.movenext
loop
end if%>

求救大神，谢谢。才五分了。

Answer 1

<%
Set rs=Server.CreateObject("Adodb.RecordSet")
rs.Open "Select top 1 id,title,content from jok where ID<"&SmallClass&" order by id desc",conn,1,1
IF not rs.eof and not rs.bof Then
response.write"[]"
else
response.write"没"
end if
rs.close
set rs=nothing
Set rs=Server.CreateObject("Adodb.RecordSet")
rs.Open "Select top 1 id,title,content from jok where ID>"&SmallClass&" order by id asc",conn,1,1
IF not rs.eof and not rs.bof Then
response.write" []"
else
response.write" 没"
end if
rs.close
set rs=nothing%>

Answer 2

大大的好，好良民