<%
………………………………………………
rs.open "select * from tablename",conn,1,3
%>
<table><tr>
<%
for i=0 to rs.fields.count-1
%>
<td><%=rs.fields.item(i).name%></td>
<% next %>
</tr>
<%
while not rs.eof
for i=0 to rs.fields.count-1
%>
<tr>
<td><%=rs(i)%></td>
</tr>
<%
next
rs.movenext
wend
rs.close
set rs=nothing
%>
</table>
<table>
<tr>
<%
i=1
do while not rs.eof
%>
<td><%=rs("id")%></td>
<%if i = 5 then
response.write "</tr><tr>"
i=0
end if
i=i+1
rs.movenext
loop
%>
</tr>
</table>
<%
………………………………………………
rs.open "select * from tablename",conn,1,3
%>
<table><tr>
<%
for i=0 to rs.fields.count-1
%>
<td><%=rs.fields.item(i).name%></td>
<% next %>
</tr>
<%
while not rs.eof
for i=0 to rs.fields.count-1
%>
<tr>
<td></td>
</tr>
<%
next
rs.movenext
wend
rs.close
set rs=nothing
%>
</table>