Hi,

I'm trying to make a dynamic slideshow, which has to pick images from dynamic directories.
Following article 3997 from George I tried codes below.
Recordset10 gives the path values, Recordset11 gives the filenames of the images to be shown in the slideshow.
First of all, I'm getting "instruction expected" error.
Before I was not getting this error, but error BOF/EOF.
Recordsets are not empty though.
URL to follow-up progresses : wimley.image-belle.com/start_slidetest.asp
Can someone help me with this please ??
1000 thanks !

Wim

AOW code :

<a href="#" onClick="GP_AdvOpenWindow('<%"84.194.85.94:1966" & (Recordset10.Fields.Item("Path".Value)%><%=Recordset11.getString(,,,|"84.194.85.94:1966" & (Recordset10.Fields.Item("Path".Value)%>','Slideshow','fullscreen=no,toolbar=yes,location=no,status=no,menubar=no,scrollbars=no,resizable=yes,channelmode=no,directories=no',700,700,'center','ignoreLink','',0,'',3,1,3,'');return document.MM_returnValue">Slideshow</a>

Recordset10 SQL :

SELECT DISTINCT SUBSTRING(Images.Filename, 0, 37) AS Path
FROM Images INNER JOIN Users ON Images.Author = Users.ID INNER JOIN Galleries ON Images.Gallery = Galleries.ID
WHERE Users.ID = 1082498853 AND Galleries.Private = 0

Recordset11 SQL :

SELECT SUBSTRING(Images.Filename, 37, 100)
FROM Images INNER JOIN Users ON Images.Author = Users.ID INNER JOIN Galleries ON Images.Gallery = Galleries.ID
WHERE Users.ID = 1082498853 AND Galleries.Private = 0<u></u><u></u>

Hi Wim,

You are missing the = sign after the &lt;%

onClick="GP_AdvOpenWindow('&lt;%

should become:

onClick="GP_AdvOpenWindow('&lt;%=

and also the | is outside the quotes it should be inside:

getString(,,,|"http

should be:

getString(,,,"|http


Greetings,
George

--------------------------------------------------
George Petrov - Founder of the Dynamic Zones
DMXzone.com, FWzone.net, FLzone.net, CFzone.net,
DNzone.com, FlashFiles.nl
--------------------------------------------------

Hi George,

Thanks for your quick answer.
With code below I'm getting "BOF of EOF is Waar, of de huidige..." error.
Recordsets are not empty though, so I'm maybe referencing wrong.
Is what I'm trying to do (dynamic path) possible anyhow ?

Thanks for your help,

Wim

AOW code :

&lt;a href="#" onClick="GP_AdvOpenWindow('&lt;%="84.194.85.94:1966" & (Recordset10.Fields.Item("Path".Value)%&gt;&lt;%=Recordset11.getString(,,,"|84.194.85.94:1966" & (Recordset10.Fields.Item("Path".Value))%&gt<img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>','Slideshow','fullscreen=no,toolbar=yes,location=no,status=no,menubar=no,scrollbars=no,resizable=yes,channelmode=no,directories=no',700,700,'center','ignoreLink','',0,'',3,1,3,'');return document.MM_returnValue"&gt;Slideshow&lt;/a&gt;

Recordsets (see previous post)

URL to check : wimley.image-belle.com/start_slidetest.asp

OEPSS,

AOW code =

&lt;a href="#" onClick="GP_AdvOpenWindow('&lt;%="84.194.85.94:1966" & (Recordset10.Fields.Item("Path".Value)%&gt;&lt;%=Recordset11.getString(,,,"|84.194.85.94:1966" & (Recordset10.Fields.Item("Path".Value))%&gt;','Slideshow','fullscreen=no,toolbar=yes,location=no,status=no,menubar=no,scrollbars=no,resizable=yes,channelmode=no,directories=no',700,700,'center','ignoreLink','',0,'',3,1,3,'');return document.MM_returnValue"&gt;Slideshow&lt;/a&gt;

Hi Wim,

Well somehow the recordsets are empty .... have you tested them and they contain records?
And you haven't used the recordsets for something else on this page?

George

--------------------------------------------------
George Petrov - Founder of the Dynamic Zones
DMXzone.com, FWzone.net, FLzone.net, CFzone.net,
DNzone.com, FlashFiles.nl
--------------------------------------------------

Hi George,

I tested both recordsets and they result indeed with records
(the filepaths for Recordset 10, the filenames for Recordset11).
So there must be something else that's wrong.

Any idea ?

Thanks,

Wim

Hi Wim,

mail me you asp page to - so I can have a more closer look

George

--------------------------------------------------
George Petrov - Founder of the Dynamic Zones
DMXzone.com, FWzone.net, FLzone.net, CFzone.net,
DNzone.com, FlashFiles.nl
--------------------------------------------------