UC知道ASP+SQLSERVER为甚么提取不了数据
来源：百度知道 编辑：UC知道 时间：2024/05/03 02:16:38
<%
set rs1=server.CreateObject("adodb.recordset")
rs1.open "select top 1 id,newsname,news,addate from news order by addate desc",conn,1,1
if rs1.eof and rs1.bof then
rs1.close
response.write "<table CELLSPACING=0 CELLPADDING=0 BORDER=0 WIDTH=""100%""><tr><td align=center>暂无最新消息！敬请留意。</td></tr></table>"
else
%>
<table width="80%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center"><%trim(rs1("newsname"))%></td>
</tr>
<tr>
<td width="100%"><%trim(rs1("news"))%></td>
</tr>
set rs1=server.CreateObject("adodb.recordset")
rs1.open "select top 1 id,newsname,news,addate from news order by addate desc",conn,1,1
if rs1.eof and rs1.bof then
rs1.close
response.write "<table CELLSPACING=0 CELLPADDING=0 BORDER=0 WIDTH=""100%""><tr><td align=center>暂无最新消息！敬请留意。</td></tr></table>"
else
%>
<table width="80%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center"><%trim(rs1("newsname"))%></td>
</tr>
<tr>
<td width="100%"><%trim(rs1("news"))%></td>
</tr>
问题非常明显了 sql 语句有问题
set rs=server.createobject("adodb.recordset")
sql="select * from new"
rs1.open sql,conn,1,1
这样是不是就可以查出数据了 调试下SQL语句