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
Printable View
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
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>
Nice 1
worked a treat, Thanx
Skeen