"YT"
04-27-2006, 10:24 AM
Is there any easy way to do this?
also
the code i have produced works in IE but does work fully in Firefox, does anyone know why?
<html><style type="text/css">
<!--
body {
background-color: #FFFFCC;
}
-->
</style>
<Body>
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "motobike"
set rs=Server.createObject("ADODB.Recordset")
rs.open "select * from motobikes", conn
%>
<Table width= "80%" border="1" align="center" bgcolor="#A4BBDD">
<th>Make</th>
<th>Model</th>
<th>Description</th>
<th>Price</th>
<th>Picture</th>
<tr>
<%Do until rs.EOF
<!--For each x in rs.fields%>
<td><div align="center">
<% response.write rs("make")&"<br>"%>
</div></td>
<div align="center">
<td><%response.write rs("model")&"<br>"%>
</div>
<div align="center">
<td><%response.write rs("description")&"<br>"%>
</div>
<div align="center">
<td><%response.write FormatCurrency(rs("Price"),2)&"<br>"%>
</div></td>
<td><a href=<%=rs("picture_FN")%> Target="_blank"</a>
<width="120"><img src="<%=rs("picture_FN")%>" width="<%=120%>" height="<%=110%>" alt="<%=100%>"/>
</td>
</tr>
<%rs.movenext
Loop%>
</Table>
</Body>
</html>
Thanks again
also
the code i have produced works in IE but does work fully in Firefox, does anyone know why?
<html><style type="text/css">
<!--
body {
background-color: #FFFFCC;
}
-->
</style>
<Body>
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "motobike"
set rs=Server.createObject("ADODB.Recordset")
rs.open "select * from motobikes", conn
%>
<Table width= "80%" border="1" align="center" bgcolor="#A4BBDD">
<th>Make</th>
<th>Model</th>
<th>Description</th>
<th>Price</th>
<th>Picture</th>
<tr>
<%Do until rs.EOF
<!--For each x in rs.fields%>
<td><div align="center">
<% response.write rs("make")&"<br>"%>
</div></td>
<div align="center">
<td><%response.write rs("model")&"<br>"%>
</div>
<div align="center">
<td><%response.write rs("description")&"<br>"%>
</div>
<div align="center">
<td><%response.write FormatCurrency(rs("Price"),2)&"<br>"%>
</div></td>
<td><a href=<%=rs("picture_FN")%> Target="_blank"</a>
<width="120"><img src="<%=rs("picture_FN")%>" width="<%=120%>" height="<%=110%>" alt="<%=100%>"/>
</td>
</tr>
<%rs.movenext
Loop%>
</Table>
</Body>
</html>
Thanks again