Do it in the sql statement instead of using pagination in ibatis. Look at limit, row_count and offset here:
http://dev.mysql.com/doc/refman/5.0/en/select.html You will probably need to use $substitution$ for the parameters, but surely some mysql stud can tell you more about that than I can. :) Larry
