BoxLang 🚀 A New JVM Dynamic Language Learn More...
With this module you can paginate any recordset. The module is primarly developed to work with qb but it can be used to paginate any query or recordset.
To install simply use CommandBox
box install cbox-paginator
Usage it's really simple:
// handler Main.cfc
query = wirebox.getInstance('QueryBuilder@qb');
q = query.from('users').paginate(5);
To loop over record:
rc.users = q.toStruct().data;
To show pagination:
rc.pag = q.render();
$
box install cbox-paginator