We'll respond shortly.
Sometimes when you’re paginating you have to run 2 queries, one for the first n records, and another for the total count.
It’s possible to get both in one query using OVER().
SELECT , COUNT() OVER() as total_count FROM blog_posts ORDER BY created_at DESC LIMIT 25;
Each record will come back with a total_count attribute, so you will have to look at one of the records to figure out the count.
To get into the spirit of working with the framework, read about Xtuple’s recent experience at http://www.xtuple.org/node/5000 and be inspired by the ease of Enyo!
Eventbrite Invite: http://enyobootcampnewyorkcity.eventbrite.com/