Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Access Problem

Reply
Thread Tools

Access Problem

 
 
Jay
Guest
Posts: n/a
 
      08-27-2004
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%>



 
Reply With Quote
 
 
 
 
Jeff Cochran
Guest
Posts: n/a
 
      08-27-2004
On Fri, 27 Aug 2004 04:33:46 GMT, "Jay" <(E-Mail Removed)> 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%>
>
>


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Very annoying error: Access to the path is denied. ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity Jay ASP .Net 2 08-20-2007 07:38 PM
DS 4125 , web interface access, CLI access problem!!! zillah Cisco 0 11-27-2006 04:54 AM
403 Forbidden: You were denied access because: Access denied by access control list Southern Kiwi NZ Computing 6 03-19-2006 05:19 AM
Desktop can't access Laptop but Laptop can access desktop =?Utf-8?B?Qmx1Y2FkZHk3MQ==?= Wireless Networking 2 11-23-2004 01:52 AM
How do I let people access the internet via an access point but not allow them access to my network yar Wireless Networking 4 09-21-2004 03:48 AM



Advertisments