<%
rs.Open sql,cn,1,3
if rs.recordcount>0 then
for i=1 to 3
if rs.eof then exit for
response.write("<tr>")
for j=1 to 2
if not rs.eof then
response.write("<td>数据</td>")
rs.movenext
else
response.write("<td> </td>")
end if
next
response.write("</tr>")
next
end if
rs.close
%>
还是一样的!如果用表格原来是
<tr>
<td><%=rs("id")%></td>
</tr>
现在是
<tr>
<%for i=1 to n '(你想要取的值)
<td><%=rs("id")%></td>
<%rs.movenext
if rs.eof then
exit for
end if%>
</tr>