Recordset Paging

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jansolo - 30 Sep 2005 09:18 GMT

I have a query that shows a bunch of items (obviously) the page limits 4
outputs per page and uses recordset paging - I link to this page (offers.cfm)
from a page that displays offers (adpage.cfm). If the user has clicked on the
link on adpage.cfm and that item is on page 3 of 10 (on offers.cfm) how do I
get the display page to display page 3 first so that the user sees that offer
without having to look through all the pages!!

Does that make sense??

Hope so, Jansolo

Reply to this Message

mxstu - 30 Sep 2005 09:27 GMT

I'm not sure what you're asking. If "offers.cfm" is the display page, and it
uses recordset paging, then just pass whatever parameters you use (ie.
url.start, url.end) through the link in "adpage.cfm".

Reply to this Message

Jansolo - 30 Sep 2005 09:58 GMT

Hi there,

No on the homepage there is a diplay of available offers - but this is limited
to displaying 3 out of the table and these change every time that the home page
is refreshed.

Therefore when you visit the home page the first offer displayed might be on
the 5th page of the recordset paging on adpage.cfm.

I need a way to link from "VIEW THIS OFFER" on the home page to adpage.cfm -
displaying the recordset page that that offer is on ie: Page 5 of Ten

Reply to this Message

mxstu - 30 Sep 2005 10:08 GMT

So I'm assuming "adpage.cfm" accepts some sort of "start/end" parameters that
determine which records are shown 1-4, 5-8, etc.. What parameters does it
accept? What type of query do you use for that page and how are the records
ordered?

Reply to this Message

Webmaster Forum / ColdFusion / Advanced Techniques / September 2005

Recordset Paging