Access Problem

[Jay]

I am trying to show pictures in a table where the name of the pic is located
in my access database. I would like two columns with a different pic in
each column. Below is the code. I guess my question is I am trying to
advance the to the next record before my wend statement. I used
rstemp.movenext and it comes up with an error saying either BOF or EOF is
true. It works if I remove the first rstemp.movenext statement, but it is
only 1 column. Any help?

<%while not rstemp.eof%>
<tr>
<td width="55%"><div align="center">
<p><img src="pics/<%= rstemp("picname")%>" width="294"
height="203"></p>
<p><%= rstemp("title")%></p>
</div></td>
<td width="45%">&nbsp;</td>
</tr>
<%rstemp.movenext%>
<tr>
<td><div align="center">
<p><img src="pics/<%= rstemp("picname")%>" width="294"
height="203"></p>
<p><%= rstemp("title")%></p>
</div></td>
<td>&nbsp;</td>
</tr>
<%rstemp.movenext
wend%>

[Jeff Cochran]

On Fri, 27 Aug 2004 04:33:46 GMT, "Jay" <jl****@optonline.net> wrote:

I am trying to show pictures in a table where the name of the pic is located
in my access database. I would like two columns with a different pic in
each column. Below is the code. I guess my question is I am trying to
advance the to the next record before my wend statement. I used
rstemp.movenext and it comes up with an error saying either BOF or EOF is
true. It works if I remove the first rstemp.movenext statement, but it is
only 1 column. Any help?
Loop your recordset only once and use a counter to add the client code
to go to the next row. Also see:

How do I change a list into a set of table rows and columns?
http://www.aspfaq.com/show.asp?id=2247

Jeff
<%while not rstemp.eof%>
<tr>
<td width="55%"><div align="center">
<p><img src="pics/<%= rstemp("picname")%>" width="294"
height="203"></p>
<p><%= rstemp("title")%></p>
</div></td>
<td width="45%">&nbsp;</td>
</tr>
<%rstemp.movenext%>
<tr>
<td><div align="center">
<p><img src="pics/<%= rstemp("picname")%>" width="294"
height="203"></p>
<p><%= rstemp("title")%></p>
</div></td>
<td>&nbsp;</td>
</tr>
<%rstemp.movenext
wend%>