You would do something like this:
Set objCommand = Nothing
' now loop through the records
%>
<table>
<%
While Not objRS.EOF
%>
<tr>
<td><%=objRS("Artist")%> </td>
<td><%=objRS("Album")%> </td>
<td><%=objRS("Year")%> </td>
</tr>
<%
objRS.MoveNext
Wend
%>
</table>
hth
================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========