Re: [htmltmpl] Help with Data Pagination

[Philip T. <phi...@gm...>]

Sometime on Jan 27, PIXpDIaC cobbled together some glyphs to say:

> achieve pagination to display result sets queried from Oracle in 
> multiple pages. Is there a plug-in for HTML:: Template to achieve

this isn't an HTML::Template problem, this is an SQL problem.  Construct 
your SQL to only return one page of data at a time given a start and 
count.  Not sure how to do it in Oracle, but MySQL has a non-standard 
addition called LIMIT that is added to the end of your SQL like this:

LIMIT 31, 10   (get 10 records starting from the 31st)

-- 
"Idiot I may be, but tied up I ain't."
         -- Gaspode the wonder dog
            (Terry Pratchett, Moving Pictures)