一个关于上一条记录和下一条记录的问题
<%
sql2="select top 1 * from HrbWeb_newsRecord where new_lanmuid="&rscyc("new_lanmuid")&" and new_deleteOk=0 and new_passed=1 and new_id>'"&rscyc("new_id")&"'" ' --下一条新闻
call CreateRS(rscyc1,sql2)
sql3="select top 1 * from HrbWeb_newsRecord where new_lanmuid="&rscyc("new_lanmuid")&" and new_deleteOk=0 and new_passed=1 and new_id<'"&rscyc("new_id")&"'" ' --下一条新闻
call CreateRS(rscyc2,sql3)
%>
<%if rscyc2.eof then %>
已经是第一条
<%else%>
<font color="#FF0000">上一条</font>:<a href="xlwz1.asp?address=<%=request("address")%>&new_Id=<%=rscyc2("new_Id")%>" class="font_black"><%=rscyc2("new_title")%></a>
<%end if%>
<%if rscyc1.eof then %>
已经是最后一条
<%else%>
<font color="#FF0000">下一条</font>:<a href="xlwz1.asp?address=<%=request("address")%>&new_Id=<%=rscyc1("new_Id")%>" class="font_black"><%=rscyc1("new_title")%></a>
<%
end if
call closeRs(rscyc1)
call closeRs(rscyc2)
%>
我是这样写的!! 可是向下好使 向上却总是 第一个 请问这是为什么? 谢谢各位了