Hi all - this one has me stumped... PLEASE HELP!!!
I have a back/forward navigation link that passes a URL.startrow number (lets call it n) - based on n - I only want to select the record that is the n'th record based on a sort order (gall_order) - (SQL SERVER).
<cfquery name="gallHomePic1st" datasource="id" maxrows="1"> SELECT id FROM gall_home ORDER BY gall_order asc </cfquery>
For e.g. - I want the 7th (14th - 21st etc) record based on gall_order asc.
Wont work - the sort_order has nothing to do with URL.startrow - this drives a thumb gallery - when you select a thumb - it pass an id through the url which in turn is retreaved by another sql query (select id from gall_home where id = URL.id). The problem is, when the user clicks 'next' to retriev the next group of thumbnails - I want the image to reflect the first thumb in this new group - hence why I nedd the '7th(14th,21st,etc)' record id. Any other ideas??? Can this be done in sql or do I need to play around with some funky coldfusion to achieve this?