Record Duplicate ?

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>

katec

Newbie Poster

2 posts since Aug 2009

Reputation Points: 10

Solved Threads: 0

This question has already been solved