[TYPO3-mvc] $query->statement('MYQUERY') doesn't count for <f:paginate />

[Henjo Hoeksma]

Yup. The contains method works nice for this :-) And paginating works again
;-)

Great!

Kind regards,

Henjo

Problems are small because we learned how to deal with them.
Problems are big because we need to learn how to deal with them.


On Fri, Mar 2, 2012 at 01:53, Domi <djgarms at gmail.com> wrote:

> Hello and thanks for the answer. The reason I choosed the statement was,
> that I am working with an MN query. My previous statement was:
>
>       $query->statement('
>>        SELECT DISTINCT t.*
>>        FROM tx_dmftravelagent_domain_**model_travel t
>>                INNER JOIN tx_dmftravelagent_travel_**branch_mm mm ON
>> mm.uid_local=t.uid
>>        WHERE t.travel_type=? AND mm.uid_foreign=? AND t.hidden=0 AND
>> t.deleted=0
>>        ', array($travelTypeUid, $branchUid));
>>
>
> I read in a previous post that MN relation doesn't work, but this works
> now for me:
> $constraint = $query->logicalAnd($query->**equals('travelType.uid',
> $travelTypeUid), $query->contains('branch', $branch));
>
> With contains() the MN relation query seems to work fine.
>
> Thanks for your responses!
>
>
> Dominic
> ______________________________**_________________
> TYPO3-project-typo3v4mvc mailing list
> TYPO3-project-typo3v4mvc@**lists.typo3.org<TYPO3-project-typo3v4mvc at lists.typo3.org>
> http://lists.typo3.org/cgi-**bin/mailman/listinfo/typo3-**
> project-typo3v4mvc<http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-project-typo3v4mvc>
>