<!--#include file="conn.asp"-->
<body>
<%
sql="select * from test"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,1
%>
<table width="777" border="1">
<%
do while not rs.eof
%>
<tr>
<td><%
if rs.eof then
exit do
end if
response.Write(rs("id"))
rs.movenext
%></td>
<td><%
if rs.eof then
exit do
end if
response.Write(rs("id"))
rs.movenext
%></td>
<td><%
if rs.eof then
exit do
end if
response.Write(rs("id"))
rs.movenext
%></td>
<td><%
if rs.eof then
exit do
end if
response.Write(rs("id"))
rs.movenext
%></td>
</tr>
<%
loop
%>
</table>
</body>