On Fri, 27 Aug 2004 04:33:46 GMT, "Jay" <jlytle@optonline.net> wrote:
[color=blue]
>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?[/color]
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
[color=blue]
> <%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%"> </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> </td>
> </tr>
> <%rstemp.movenext
> wend%>
>
>[/color]
Access Problem 
