How do you print a Field Name to a table?

[powahusr]

I’m currently learning ADO and do not know how to print field names to a table in an ASP document. (Also Posted in the "Microsoft: ActiveX" forum).

The following code prints the contents of the selected Table in a database but not the field names. I want the field names printed at the top of each respective column, how do you do it. Thanks in advance.

Here is the code:

<%
set conn=Server.CreateObject(&quot;ADODB.Connection&quot
conn.Provider=&quot;Microsoft.Jet.OLEDB.4.0&quot;
conn.Open &quot;c:\ASP\db4.mdb&quot;
set rs=Server.CreateObject(&quot;ADODB.recordset&quot
rs.Open &quot;Select * from uid&quot;, conn
%>

<table border=&quot;1&quot; width=&quot;100%&quot; bgcolor=&quot;#FFFFFF&quot; cellspacing=&quot;1&quot;>

<tr>
<%do until rs.EOF%>
<%for each x in rs.Fields%>
<td><%Response.Write(x.value)%> </td>
<%next
rs.MoveNext%>
</tr>
<%loop
rs.close
conn.close
%>

 

[Guest_imported]

Try this:

comment out or delete this line <%do until rs.EOF%>
<%for each x in rs.Fields%>
<td><%= x.name%></td>
<%
next
comment out or delete this line rs.MoveNext
%>
</tr>
<%
comment out or delete this line loop
rs.close
conn.close
%>

 

[powahusr]

Worked Great!! Thanks a lot!!!