<%newsid=request("newsid")
sql="select * from jijin where newsid="&newsid
set rs=conn.execute(sql)
if not (Rs.eof and rs.bof) then%>
| |
 " /> |
| <%=rs("newstitle")%> |
| 发布日期：<%=rs("addtime")%> |
|
<%=rs("newscontent")%> |
| <%set rsp=server.createobject("adodb.recordset")
sqlp="select top 1 * from jijin where newsid<"&rs("newsid") &" order by newsid desc"
rsp.open sqlp,conn,1,1
if not rsp.eof then
while not rsp.eof%>
上一条:"><%=rsp("newstitle")%>
<%
rsp.movenext
wend
end if
rsp.close
set rsp=nothing
%> |
|
<%set rsn=server.createobject("adodb.recordset")
sqln="select top 1 * from jijin where newsid>"&rs("newsid") &" order by newsid asc"
rsn.open sqln,conn,1,1
if not rsn.eof then
while not rsn.eof%>
下一条:"><%=rsn("newstitle")%>
<%
rsn.movenext
wend
end if
rsn.close
set rsn=nothing
%> |
<%end if
rs.close:set rs=nothing%>
|
