Loops

[Skeen]

Hiya

I want to create a table in html to display a view from an oracle database, however I can only seem to print the last record. Is it possible to perform a loop in html? If so could anybody help withthe syntax?

Cheers 'n' Beers

[dadames]

Something like this...

<table>
<%
rsShopCart.MoveFirst
Do Until (rsShopCart.eof)
' Write rows of data
%>
<tr>
<%
For i = 0 to rsShopCart.Fields.Count - 1
' Display all columns
%>
<td><%= rsShopCart.Fields(i) %></td>
<%
Next
%>
</tr>
<%
rsShopCart.movenext
Loop
%>
</table>

[Skeen]

Nice 1

worked a treat, Thanx

Skeen