注册 登录
编程论坛 ASP技术论坛

新手入门,求大家指点一下

温泉猫 发布于 2010-04-19 10:35, 417 次点击
那位大侠指点一下我,想给下面这段代码控制一下行的显示,显示成17行。3Q


<table width="177"  height="180" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" align="center">
                  <%
sqlprom = "select * from News where online=true  and NewsClass<>'' order by uup desc,Pubdate desc"
set rsnews=Server.CreateObject("ADODB.RecordSet")
rsnews.open sqlprom,conn,1,1
if rsnews.eof and rsnews.bof then
%>
                  <tr>
                    <td valign="top" height="18"><div class="newsline3">&nbsp;&nbsp;暂时没有新闻公告</div></td>
                  </tr>
                  <%
else
Do while Not rsnews.eof
%>
                  <tr>
                    <td valign="top" height="18"><div class="newsline3">&nbsp;&nbsp;&middot;<a href="news.asp?NewsId=<%=Cstr(rsnews("NewsId"))%>" title="<%=rsnews("NewsTitle")%>"><%=rsnews("NewsTitle")%></a></div></td>
                  </tr>
                  <%
rsnews.movenext
loop
end if
rsnews.close
set rsnews=nothing
%>
                </table>
2 回复
#2
aspic2010-04-19 10:36
sqlprom = "select Top 17 * from News where online=true  and NewsClass<>'' order by uup desc,Pubdate desc"
#3
温泉猫2010-04-19 10:39
谢谢大侠
1