[TYPO3-mvc] Query Statement and paginator

[Franz Koch]

Hey,

> $query = $this->createQuery();
> $query->statement('...');
> return $query->execute();
...
> can anyone see a reason for that?
> thanks in advance

The paginate widget can't manipulate custom statements - easy as that. 
The Widget will use the method "setLimit" which will only be taken into 
account/processed if no custom statement was set. So you have to build 
your query using the QOM or write a own pagination Widget that'll parse 
and adjust raw SQL statements.

-- 
kind regards,
Franz Koch