[symfony-users] Re: Help with doctrine SQL

2010-05-24 Thread grahamj42
Simone, As soon as one uses a function in the SELECT clause, the result is no longer an object made persistent in the database, it's a new class (a subclass (not yet defined) of DoctrineObject). Because you are using SUM, there is no unique key for the result (except in the situation where only o

[symfony-users] Re: Help with doctrine SQL

2010-05-24 Thread Simone Fumagalli
On May 24, 6:20 pm, Philipp Mohrenweiser wrote: > Not a collection ? so you should probably use a limit 1 statement ... > but if you  want to get back multiple entrys the collection should be > the right thing !? As you can see I've SUM in my select so I want an object with the sum of the found