UC知道asp中提取全部数据
来源：百度知道 编辑：UC知道 时间：2024/06/07 22:07:34
如何在asp中提取newsname字段的全部内容
<%dim newsid
newsid=request.QueryString("id")
set rs=server.CreateObject("adodb.recordset")
if newsid="" then
rs.open "select newsid,newsname,newscontent,addname,adddate,viewnum from news order by adddate desc",conn,1,3
else
rs.open "select * from news where newsid="&newsid&"",conn,1,3
end if
rs("viewnum")=rs("viewnum")+1
rs.update
%>
怎么这样写不对吗？
<%dim newsid
newsid=request.QueryString("id")
set rs=server.CreateObject("adodb.recordset")
if newsid="" then
rs.open "select newsid,newsname,newscontent,addname,adddate,viewnum from news order by adddate desc",conn,1,3
else
rs.open "select * from news where newsid="&newsid&"",conn,1,3
end if
rs("viewnum")=rs("viewnum")+1
rs.update
%>
怎么这样写不对吗？
那去参考吧：
<!--#include file="../j_conn/conn.asp"-->
<link href="../css/style.css" rel="stylesheet" type="text/css" />
<div class="articleleft">
<h2> 最新留言>></h2>
<%
set rsr=server.createobject("adodb.recordset")
sqlr="select top 10 * from j_feedback where f_is='0' and len(trim(f_answer))>0 order by f_id desc"
rsr.open sqlr,conn,1,1
if rsr.recordcount=0 then
response.write "暂无！"
else
for i=0 to rsr.recordcount
%>
<P><div><a href="detail.asp?id=<%=rsr("f_id")%>"><%=rsr("f_content")%></a></div></P>
<%
rsr.movenext
if rsr.eof then
i = i + 1
exit for
end if
next
end if
rsr.close
set rsr=nothing<