主题:[讨论]请教高手,首页调用文章标题数目不按预设显示怎么办?
大家好,我在学习中遇到了一些问题,其中在首页文章调用时应该调用8个文章题目,结果却无休止的超过八个标题还在显示,请教高手哪的问题,怎么解决?在线等待。
<table width="201" border="0" align="center" cellpadding="0" cellspacing="0" class="td" style="border-right:#cccccc 1px solid;border-left:#cccccc 1px solid">
<%set rs=server.createobject("adodb.recordset")
sql="select top 8 Title,Content,NID,Addtime from Ms_Note where TypeID=2 order by Addtime desc"
rs.Open sql,conn,1,1
if not (rs.eof and rs.bof) then
do while not rs.eof%>
<tr>
<td width="15%" height="22" align="center" style=""><font color="#990000">·</font></td>
<td width="85%" bgcolor="#FFFFFF" style="">
<%
response.Write("<a href=Noteview.asp?NID="&rs("NID")&" target=_blank title="&left(rs("Content"),30)&"...>"&left(rs("Title"),18)&"</a> ")
if datediff("d",rs("Addtime"),date())<3 then
response.write("")
end if
%> </td>
</tr>
<%rs.movenext
loop
else
response.write("<tr><td colspan=3 align=center><font color=red>没有网站活动</font></td></tr>")
rs.close
end if%>
</table>[em18][em18]
<table width="201" border="0" align="center" cellpadding="0" cellspacing="0" class="td" style="border-right:#cccccc 1px solid;border-left:#cccccc 1px solid">
<%set rs=server.createobject("adodb.recordset")
sql="select top 8 Title,Content,NID,Addtime from Ms_Note where TypeID=2 order by Addtime desc"
rs.Open sql,conn,1,1
if not (rs.eof and rs.bof) then
do while not rs.eof%>
<tr>
<td width="15%" height="22" align="center" style=""><font color="#990000">·</font></td>
<td width="85%" bgcolor="#FFFFFF" style="">
<%
response.Write("<a href=Noteview.asp?NID="&rs("NID")&" target=_blank title="&left(rs("Content"),30)&"...>"&left(rs("Title"),18)&"</a> ")
if datediff("d",rs("Addtime"),date())<3 then
response.write("")
end if
%> </td>
</tr>
<%rs.movenext
loop
else
response.write("<tr><td colspan=3 align=center><font color=red>没有网站活动</font></td></tr>")
rs.close
end if%>
</table>[em18][em18]