New Question...
If you are wanting to have a series of pictures appear in a particular order.
How would you do this.
I have it setup so that I have an order row in my Access Database. But when I go to My test page that is suppose to display three pictures to see the settings, the results End up showing that I only have one Picture showing not the other two. All three spaces are the same picture. So what setting am I missing? I havent really even gotten around to playing with order changing but I would also like to know everyones suggestions on it also.
Thank you in advanvced.

sounds more like a problem with your repeat/stepthrough of the recordset..Pop your code up for us to check out...

:: Son, im Thirty.... ::

OK here is the info from the page
First the header info

set rsPictures = Server.CreateObject("ADODB.Recordset"
rsPictures.ActiveConnection = MM_Lonestar1_STRING
rsPictures.Source = "SELECT * FROM picts WHERE Product_name = '" + Replace(rsPictures__MMColParam, "'", "''" + "' ORDER BY pict_position ASC"
rsPictures.CursorType = 0
rsPictures.CursorLocation = 2
rsPictures.LockType = 3
rsPictures.Open()
rsPictures_numRows = 0

Here is the pitcure place holder
<img src="images/<%=(rsPictures.Fields.Item("Pict_File".Value)%>">

If you need some more info Let me know, I will reply a lot faster. My Spam blocker was holding the notifacation. Corrected that.



Edited by - Bubbajoe on 17 May 2002 05:58:54

I think what youve done is just put this code...

<pre id=code><font face=courier size=2 id=code>&lt;img src="images/&lt;%=(rsPictures.Fields.Item("Pict_File".Value)%&gt;"&gt; </font id=code></pre id=code>
into three places on your page, this will show only thi First picture 3 times because there is nothing telling your recordset to step to the next one.

Put that code inside a 1 col 1 row table and apply the Repeat Region server behaviour to this table.

This should sort you out .....

Cheers
Leed

:: Son, im Thirty.... ::

First, Thank You for the Help.
OK I did that, which it works good. Now. I want to raise the difficulty level one notch.
I would like to have them each in a specific location. Below is a picture of what I am wanting.
<img src="users.htcomp.net/Quake_site/items/pictView.gif" border=0>
So in you opinion how shhould this be done.

Create table with three rows and some ASP code between them.
HTML CODE FOR TABLE
&lt;% While (Not Recordset.EOF) 'Loop through all records %&gt;
HTML CODE FOR ROW 1
&lt;%
Recordset.MoveNext() ' Move to next record
If (Not Recordset.EOF) Then ' If it's not last record display Row 2
%&gt;
CODE FOR ROW 2
&lt;%
Recordset.MoveNext() ' Move to next record
End If
If (Not Recordset.EOF) Then ' If it's not last record display Row 3
%&gt;
CODE FOR ROW 3
&lt;%
Recordset.MoveNext()
End If
Wend
%&gt;
ENDING HTML CODE FOR TABLE

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
First, Thank You for the Help.
OK I did that, which it works good. Now. I want to raise the difficulty level one notch.
I would like to have them each in a specific location. Below is a picture of what I am wanting.
<img src="users.htcomp.net/Quake_site/items/pictView.gif" border=0>
So in you opinion how shhould this be done.


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic

TalkZone Manager

Edited by - vfarcic on 17 May 2002 16:16:07

Edited by - vfarcic on 17 May 2002 16:16:47

<font size=4>Whoo Hoo!</font id=size4>
Thank you guys! That worked I knew there was something that was needed for each table but I guess I just was not able to phrase it right to fine the right info.

You guys are the best.