Displaying the data

[Steve]

If anyone could tell me how to display data from DB
not horizontally, but verticaly in a loop, e.g.
Column1 Data1
Column2 Data2

Thank you.

[Kris Eiben]

Have you tried:
do until rs.EOF
response.write rs("datafield") & "<br>"
rs.movenext
loop

Steve wrote in message <3916b8ac$1@news.devx.com>...
>
>If anyone could tell me how to display data from DB
>not horizontally, but verticaly in a loop, e.g.
>Column1 Data1
>Column2 Data2
>
> Thank you.

[Joe Henderson]

One way you can achieve this is using ADO "movenext"

ex: <table><tr><td><%"data"%></td
<%your variable.movenext%>
<td><%"data"%></td></tr>

<%your variable.movenext
loop
%>

</table>

"Steve" <vbfan22@hotmail.com> wrote:
>
>If anyone could tell me how to display data from DB
>not horizontally, but verticaly in a loop, e.g.
>Column1 Data1
>Column2 Data2
>
> Thank you.