The code below when qurried is supposed to return a picture of a plant(PlantPic) and all other fields.
It worked perfectly for just once, now when I querry it it rather tries to open a file...come someone pls tell me what's wrong? Thanks.
<%
'Iterating through the recordset until the EOF is reached
Response.write "<ul>"
Do While NOT rs.EOF
%>
<tr>
<td rowspan=“4”><IMG SRC="images/<%=RS("PlantPic"
%>" border="0" width="100"> </td>
<th><font size="2"><%
Response.Write RS("ScientificName"
%></font></th>
<th><font size="2"><%
Response.Write RS("OtherNames"
%></font></th>
<th><font size="2"><%
Response.Write RS("Uses"
%></font></th>
<th><font size="2"><%
Response.Write RS("ScientificRef"
%></font></th>
</tr>
<%
RS.Movenext
loop
'Clean up...
rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing
%>
</table>
</body>
</html>
It worked perfectly for just once, now when I querry it it rather tries to open a file...come someone pls tell me what's wrong? Thanks.
<%
'Iterating through the recordset until the EOF is reached
Response.write "<ul>"
Do While NOT rs.EOF
%>
<tr>
<td rowspan=“4”><IMG SRC="images/<%=RS("PlantPic"
<th><font size="2"><%
Response.Write RS("ScientificName"
<th><font size="2"><%
Response.Write RS("OtherNames"
<th><font size="2"><%
Response.Write RS("Uses"
<th><font size="2"><%
Response.Write RS("ScientificRef"
</tr>
<%
RS.Movenext
loop
'Clean up...
rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing
%>
</table>
</body>
</html>