Problem with paginate method

[Uwe Wagner]

The "ORDER BY" expressed as 'order'=>'...' clause does not seem to work as shown below:

$grenzwerte = new DB\SQL\Mapper($db,'chemdb_agw');

$list = $grenzwerte->paginate($page-1, $limit, array('order'=>'gw_bezeichnung'));

Is it possible to combine a exec method with paginate? Something like:

$list = $f3->get('DB')->exec("SELECT * FROM chemdb_agw ORDER BY gw_bezeichnung")->paginate($page-1, $limit)

[ikkez]

paginate works as expected. it is not possible to combine the result from exec with any mapper method.. what you want is to add "LIMIT 10,10" or something.

[Uwe Wagner]

It works now with the folloing changes:

$options = array('order'=>'gw_bezeichnung DESC');
$list = $grenzwerte->paginate($page-1, $limit, NULL, $options);


The documentation on this point is not entirely clear.

[bcosca]

The documentation is quite clear on this point. The third argument is meant to be the query filter (WHERE clause) and not the additional modifiers (ORDER and LIMIT clauses).