Re: Help with Data Pagination

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)


-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642