ModPerl List,
Forgive me if this is offtopic, but I am attempting to paginate a set of
returned SQL records using mod_perl connecting to a MySQL server (through
DBI/DBD::mysql). I believe this can be accomplished using the RANGE() SQL
function, but to my knowledge it is not supported by MySQL.
Does anyone have a proved method of separating results (1-10, 10-20, etc. -
think of AltaVista returning search results and separating them into pages),
using as little resources on the webserver as possible (would like to push
most of the task to SQL server)? Thanks, in advance, for any assistance.
