[TYPO3-mvc] complex queries

[Thomas "Thasmo" Deinhamer]

You can checkout the current SVN trunk [1] to get
Extbase working with an array as parameter for logicalAnd().

Thomas

[1] https://svn.typo3.org/TYPO3v4/CoreProjects/MVC/extbase/trunk/


Am 30.04.2010 13:20, schrieb Cornelius Illi:
> Hi Jochen,
>
> i was searching for a more generic approach for the PaginationClass, in
> order to hand in either a normal query or a query using
> $query->statement and that the PaginationClass has the possibility to
> figure out how to count rows ifself. Unfortunately i think I don't have
> to use this approach anymore as I changed the table-definition and
> therefore don't have to use the CONCAT_WS-Statement anymore :P
>
> Unfortunately, it took me one hour to figure out that the API-Doc at
> http://doxygen.frozenkiwi.com/typo3/html/d8/d31/classTx__Extbase__Persistence__Query.html
> refers to the current beta release, thats why a logicalAND didn't accept
> on array of constraints. Do you know when the next stable of extbase and
> fluid will be released. Would be interesting for the client.
>
> Thanks and regards,
> Cornelius
>
> Am 30.04.2010 09:48, schrieb Jochen Rau:
>> Hi Cornelius.
>>
>> On 29.04.10 00:22, Cornelius Illi wrote:
>>> Thanks everyone for support!
>>> However I got some problems when working with $query->statement():
>>> I also want to have the possibility to count rows (e.g. for pagination).
>>> I therefore have a Paginator-Class that gets a Query
>>> (*Tx_Extbase_Persistence_Query).
>> Maybe I did not get the point here, but why does
>>
>> $query->statement('SELECT COUNT(*) FROM ....')->execute();
>>
>> not work for you?
>>
>> Regards
>> Jochen
>> _______________________________________________
>> TYPO3-project-typo3v4mvc mailing list
>> TYPO3-project-typo3v4mvc at lists.typo3.org
>> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-project-typo3v4mvc
>