Is there a script that paginate the output of a query?

[ndeeley]

Hi there,

Realise that this might not be a CF answer to a CF question, but does anyone know of any script that will paginate th eoutput of a CF query?

I have CF displaying notes added to a item. Rather than display them down the page in a table I'd like to show just one note with forward and backward links to the next note from the queryset (or no links if there aren't any) Can this be done?

Thanks
Neil

[acoder]

<cfoutput> has startrow and maxrows attributes which you can use for pagination.

It could be argued that this should be done at the SQL level, but that depends on your database, e.g. using LIMIT in MySQL.