[TYPO3-mvc] complex queries

[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
>