说明,我需要调用2个新闻以后就分两列排比如调用4个新闻就排成2行2列请高手代码如下:<table cellspacing=0 cellpadding=0 width="100%" border=0 class=table-xia><tbody><%i=0set rs=server.CreateObject("adodb.recordset")rs.open "select top 4 newsname,adddate,newsid from news order by adddate desc",conn,1,1if rs.eof and rs.bof thenresponse.write "<center>目前还没有新闻!</center>"elsedo while not rs.eofi=i+1%><tr><td height=20 valign=center> <img height=11 src="images/images0112.gif"width=15 align=absMiddle border=0><%dim iresponse.write "<a href=# onClick=""javascript:window.open('news.asp?id="&rs("newsid")&"','','width=432,height=288,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');return false;"" title="&year(rs("adddate"))&"年"&month(rs("adddate"))&"月"&day(rs("adddate"))&"日发布>"&trim(rs("newsname"))&"</a><br>"%></td></tr><tr><td background=images/bg_04.gif border=0></td></tr><% if i>=4 then exit dors.movenextloopend ifrs.closeset rs=nothing%></tbody></table>
參考答案:比较简单,楼上的方法是对的
下边是我对这个这个问题的解决方法,请指教下!
<table width="400" border="0" cellspacing="0" cellpadding="0">
<%
set rs=server.CreateObject("adodb.recordset")
rs.open "select top 4 newsname,adddate,newsid from news order by adddate desc",conn,1,1
if rs.eof and rs.bof then
response.write "<tr><td><center>目前还没有新闻!</center></td></tr>"
else
for i=1 to rs.recordcount
response.write "<tr>"
for j= 1 to 2%>
%>
<td>要显示的内容!</td>
<%rs.MoveNext
If rs.EOF Then Exit For
next
If rs.EOF Then Exit For
response.write "</tr>"
next
rs.close
set rs=nothing
%>
</table>