Custom Sql Statment + QDataRepeater and Pagination

Custom Sql Statment + QDataRepeater and Pagination

Login or register to post comments

2 replies [Last post]

Sun, 03/06/2011 - 17:36

Domanitrogen

Offline

Joined: 05/09/2009

Hi

I am using a custom sql query and Qdata reapter

$objDatabase = QApplication::$Database[1];
$objDbResult = $objDatabase->Query($this->strQuery);
$this->dtrUnits->DataSource = UnitFeatures::InstantiateDbResult($objDbResult);

and its working. The problem is Pagination is not. I guess i have to use the limit
But how to do so with custom sql script

thanks in advance

Mon, 03/07/2011 - 16:01

#1

Domanitrogen

Offline

Joined: 05/09/2009

problem solved in the other forum

http://qcu.be/content/pagination-custom-query

Tue, 03/08/2011 - 21:16

#2

alex94040

Offline

Joined: 11/06/2008

Do you have a few minutes to put together this solution as an example to go to http://examples.qcu.be? I think it'd be incredibly helpful for others.