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
_______________________________________________
Html-template-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/html-template-users
