Hi,
I want to order my users by the number of computer they got.
(as i'm using the pager, i only need to return the query)
I tryed :
$q = $this->createQuery('a')
->addSelect('a.*, COUNT(cp.id) as count')
->leftJoin('a.Computers cp')
->orderBy('count');
return $q;
but doesn't work.
I also tryed what we can find on Doctrine website :
$q = Doctrine_Query::create()
->select('u.*, COUNT(cp.id) count')
->from('User u')
->innerJoin('u.Computers p')
->orderby('count');
Is there's something wrong ?
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
