[TYPO3-mvc] Using SQL count function in ExtBase query
    Franz Koch 
    typo3.RemoveForMessage at elements-net.de
       
    Thu Aug 19 15:51:12 CEST 2010
    
    
  
Hey,
>> $query = $this->createQuery();
>> return $query->statement('SELECT ...')->execute();
>>
>>
>> If you just like to use the QOM to build such a query (so outside of a
>> repository) it should be possible, but I can't tell you how as I'm not
>> too familiar with internals of the QOM layer yet.
>
> Hey Franz,
>
> thanks for your suggestion, I didn't think about that, but as I cannot
> use domain objects to be mapped on the results, this will work fine!
ok, then you can't use the suggestion above, as extbase will try to map 
the results to a domain object (except if you instantiated a custom 
QOM). In that case easiest would be to use $GLOBALS['TYPO3_DB'] just 
like before, although not the nicest way.
-- 
kind regards,
Franz Koch
    
    
More information about the TYPO3-project-typo3v4mvc
mailing list