Selecting * where row = from DB

[joey o.]

Is there an easy way to set each item in a field to a cell of a table without having to refer to each field when I execute "Select * from table where row = rownum"? In other words, Is there a fields collection of a row that I can scroll through and assign to cells in a table in same order?
If so do you have an example?

[Ianpbaker]

hi joeyo.

You can use the following, (I've ommited some code, which you should know

Dim iFlag
Dim objRec


'open connection's and recordset

While not objrec.eof
%>
<tr>
<%
For iflag = 0 to objrec.fields.count - 1
%><td><% = objrec(iflag) %></td>
<%
Next
%>
</tr>
<%
objRec.Movenext
Wend
%>

Hope this helps

Ian