Hi. This should be simple for the experienced. This code pulls the first record twice, but the rest are fine. I can't figure it out! Thanks for looking!
--------
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("products.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Model, Volts_Hz, BTUH, Max_Amps, Max_Temp, '<a href='+Drawing+'>'+Model+'</a>' AS Drawing FROM VAirConditioners ORDER BY BTUH ASC"
rs.Open sql, conn
%>
<table id="header205" align="center">
<tr>
<%
for each x in rs.Fields
response.write("<th>" & x.name & "</th>")
%>
<td "nowrap="nowrap" class="tablesytle4"><%Response.Write(x.value)%></tr>
<tr><%next %>
<%do until rs.EOF%>
</tr>
<%
for each x in rs.Fields
response.write("<th>" & x.name & "</th>") %>
<td "nowrap="nowrap" class="tablesytle4"><%Response.Write(x.value)%>
<tr>
<%next
rs.MoveNext%>
</td> </tr>
<%loop
rs.close
conn.close
%></table>