Skip to main content
T
tomtomtom7147938
Inspiring
November 21, 2009
Question

Splitting a query result

  • November 21, 2009
  • 1 reply
  • 304 views

Hi all

Assume I have a query result with 200 records. I would like to split this result in blocks of 10 so. 10 results should then be represented on a html (cfm) page and below (or above) I have sort of a navigation indicating the list of pages (in my case 10) with may be 'previous' and 'next' buttons. Would be even nicer if the 10 numbers would be represented as buttons and clickable and may be the selected one is highlighted.

I think it's quite a standard function but I haven't got a clue on how to program this. In the best case there is a function or an example I could download and implement. So far I didn't find anything I understood.

Thank you for help

Kind regards

This topic has been closed for replies.

1 reply

ilssac
ilssac
Inspiring
November 21, 2009

The function you are describing is called "next n records"

Here are a few links that should describe it in much detail complete with examples and code.

http://www.google.com/search?q=coldfusion+next+n+records&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices