Forums

This topic is locked

Recordset Paging (move to next/last record)

Posted 18 Jun 2004 01:44:51
1
has voted
18 Jun 2004 01:44:51 g m posted:
Ok another question, this one has to do with recordset paging.

I have multiple recordsets on one page. There are 2 different recordsets where I would like to have recordset paging to move between records. The odd thing is (or not so odd I guess) is that I can setup move to next/last record no problem on one recordset, but when I add it to links on the other recordset, it effects the previous one by changing the Recordset it is related to.

So, if I have rsOne and rsTwo and setup move to next/last record with rsONE. As soon as I setup move to next/last record on rsTwo it changes the code on the ones for rsOne to rsTwo. I hope this makes sense.

Is there a workaround for this?

Thanks in advance for any direction on this,

Gil

Replies

Replied 18 Jun 2004 16:35:39
18 Jun 2004 16:35:39 Dave Thomas replied:
i dont know if its possible to navigate 2 reordsets at once using asp, but if you can then you should go into code view and copy the code created for the nav buttons and recreate it using the rsTwo name. and see how that goes.

Regards,
Dave

[img]www.nova-cs.co.uk/DmxAvatar.jpg" border="0">

[DWMX 2004]|[FlashMX 2004 Pro]|[Studio MX 2004]|[SQL]|[Access2000/2002]|[ASP/VBScript]|[XP-Pro]
Replied 18 Jun 2004 17:49:02
18 Jun 2004 17:49:02 g m replied:
I will experiment with it....

Thanks!

Gil

Reply to this topic