Paged queries with QxORM

Forum for posting problems using QxOrm library

Paged queries with QxORM

Postby mdw » Wed May 25, 2016 10:40 am

Does QxORM provide some sort of paged results or cursors?

In MS Linq you could write something like this:
Code: Select all
query = query.Take(page).Skip((page - 1) * pageSize);
mdw
 
Posts: 34
Joined: Mon Feb 15, 2016 2:45 pm

Re: Paged queries with QxORM

Postby mdw » Wed May 25, 2016 1:14 pm

Ah, maybe I could do like this:

Code: Select all
query = query.limit(pageSize, (page-1) * pageSize);
mdw
 
Posts: 34
Joined: Mon Feb 15, 2016 2:45 pm

Re: Paged queries with QxORM

Postby qxorm » Wed May 25, 2016 3:58 pm

Hello,

Yes : qx::QxSqlQuery::limit() is the method to use.
qxorm
Site Admin
 
Posts: 481
Joined: Mon Apr 12, 2010 7:45 am


Return to QxOrm - Help

Who is online

Users browsing this forum: No registered users and 12 guests