findAll()function and the
OFFSET, and the Microsoft SQL Server adapter will use
TOPand some tricky sub queries.) Turn on debugging in the ColdFusion Administrator if you want to see exactly what's going on under the hood.
findAll()statement around a little:
findAll()function on the Book class instead, and thereby we ensure that the pagination is based on the books and not the authors. In this case, we will always get 25 records back.
pagination()function which returns a struct with keys