Showing in an HTML table continuing data

[Amateur]

Dear Sirs
I would like to show my data in a table modus.
So I did the following:

<tableheader border="1" width="100%">

<tr>
<td align="left" valign="top" class="formpagetablelabel"> tradeid</td></td>
<th align="left" valign="top"
class="formpagetablelabel"> clearingnumber</th></td>
<th align="left" valign="top" class="formpagetablelabel"> fecha</th>
<td align="left" valign="top" class="formpagetablelabel"> bought</td>
<td align="left" valign="top" class="formpagetablelabel"> sold</td>
<td align="left" valign="top" class="formpagetablelabel"> commodity</td>
<td align="left" valign="top" class="formpagetablelabel"> month</td>
<td align="left" valign="top" class="formpagetablelabel"> year</td>
<td align="left" valign="top" class="formpagetablelabel"> price</td>
<td align="left" valign="top" class="formpagetablelabel"> contractvalue</td>
</tr></table><table>
<tr>
<td><input class="formpagetablefield" type="text" name="tradeid" size="6"
Value="<%=trim(Session("tradeid"))%>"></td>
<td width="258"><input class="formpagetablefield" type="text"
name="clearingnumber" size="50"
Value="<%=trim(Session("clearingnumber"))%>"></td>
<td><input class="formpagetablefield" type="text" name="fecha" size="50"
Value="<%=trim(Session("fecha"))%>"></td>
<td><input class="formpagetablefield" type="text" name="bought" size="12"
Value="<%=trim(Session("bought"))%>"></td>
<td><input class="formpagetablefield" type="text" name="sold" size="12"
Value="<%=trim(Session("sold"))%>"></td>
<td><input class="formpagetablefield" type="text" name="commodity" size="30"
Value="<%=trim(Session("commodity"))%>"></td>
<td><input class="formpagetablefield" type="text" name="month" size="50"
Value="<%=trim(Session("month"))%>"></td>
<td><input class="formpagetablefield" type="text" name="year" size="50"
Value="<%=trim(Session("year"))%>"></td>
<td><input class="formpagetablefield" type="text" name="price" size="12"
Value="<%=trim(Session("price"))%>"></td>
<td class="formpagetablelabel"><input class="formpagetablefield" type="text"
name="contractvalue" size="8" Value="<%=Session("contractvalue")%>"><font
class="formpagetablefield"> US$</div></td>
</tr>
</table>


I would like to see a table header like "tradeid,clearingnumber" etc - and
underneath the list of records.
can someone tell me how to get this because in the moment I only see one
record always it's not continuing writing the list? Somehow it should be
automatically showing all records.
Thanks for your help
Klaus

 

[aaron.kempf]

add a do until rst.EOF

change your shit to have a recordset instead of session variables

and add rst.movenext
and loop at the bottom