0

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>
1
Contributor
1
Reply
2
Views
8 Years
Discussion Span
Last Post by katec
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.