I'm pretty sure that you can encourage CakePHP to do this wihtout
changing the afterFind function as follows:
$this->Test->find(
'all',
array (
'fields' => array ('test.field3', 'SUM(field1) AS
`test.Sum1`', 'SUM(field2) AS
`test.Sum2`'),
'group' =>
Figured out what the problem was for me. I had inserted this afterFind
() function in the app Model
http://teknoid.wordpress.com/2008/09/29/dealing-with-calculated-fields-in-cakephps-find/
so that the calculated fields show up in the appropriate models when
returned, and not in an ambiguous array
Just checked on cakes 1.2.5 and 1.2.4 - all fine.
Query:
$this->Test->find(
'all',
array (
'fields' => array ('field3', 'SUM(field1) AS Sum1',
'SUM(field2) AS
Sum2'),
'group' => array ('field3')
)
);
Generated SQL:
SELECT `Test`.`field3`,
I have this same problem happening right now. You can put other fields
in that are not sums and they are returned just fine, but of all the
SUMs you put it it only returns the first occuring one. It is bizzarr.
It is generating the appropriate SQL statement, because when i take
the SQL statement it
See: http://book.cakephp.org/view/74/Complex-Find-Conditions
CTRL+F: "How about GROUP BY?" on that page. See the MIN() usage, I'd
just try to use it twice (and SUM instead of MIN)
On Nov 29, 2:13 am, Dave wrote:
> They really let you use PHP Frameworks for your homework?
>
> On Sat, Nov 28, 2009
They really let you use PHP Frameworks for your homework?
On Sat, Nov 28, 2009 at 3:13 PM, John Andersen wrote:
> Please copy/paste the find statement into the post, so that we better
> may be able to see what may be the problem ;)
> Enjoy,
>John
>
> On Nov 28, 3:48 pm, Robin Marx wrote:
> >
Please copy/paste the find statement into the post, so that we better
may be able to see what may be the problem ;)
Enjoy,
John
On Nov 28, 3:48 pm, Robin Marx wrote:
> Since I can't seem to find the answer on google, nor in the docs, I
> hope someone here can help me.
>
> Whenever I try to do
Since I can't seem to find the answer on google, nor in the docs, I
hope someone here can help me.
Whenever I try to do a query with more then 1 SUM-field in it, it will
only return the first SUM-field, not the other ones in its results.
So for instance :
SUM( amount1 ) as amountOne, SUM( amount
