what if we have a stored procedures that takes in 'startrow' and 'endrow' as parameters. Based on those it returns the results back. If a sp like that were to be called using iBatis with pagination then will the SP be called again to get NEXT set of results?
On Fri, May 15, 2009 at 12:15 PM, Larry Meadors <larry.mead...@gmail.com>wrote: > 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 >
