How to obtain the total number of records for pagination queries

[hs205118]

I have a database table with 100 pieces of data. I want to query 1-50 pieces of data first. In order to obtain the total number of pages, I need to query the total number of records (100). What should I do?
Thanks!

[QxOrm]

Hello,

To get total number of records, you can use :
qx::dao::count<T>(const qx::QxSqlQuery & query = qx::QxSqlQuery(), QSqlDatabase * pDatabase = NULL)

Example from qxBlog sample project :
qx::dao::count<author>();

For pagination, you can use :
qx::QxSqlQuery::limit(int rowsCount, int startRow = 0, bool withTies = false)

Example from qxBlog sample project (you can remove .distinct() in your case) :

   QList<blog> listOfBlogDistinct;
   qx_query queryDistinct; queryDistinct.distinct().limit(10);
   daoError = qx::dao::fetch_by_query(queryDistinct, listOfBlogDistinct, NULL, QStringList() << "blog_text");