how to make sum query on cake ?

2010-08-09 Thread Cruisine
hi i'm still newbie at cakephp. and i still wondering how to make sum query on cakephp ? for example i want to make a query like this : select count(id) as customer, sum(payment) as money from customer where department_id=1 how to implement it on cakephp ?? do you have the solution ? i need ur

Re: how to make sum query on cake ?

2010-08-09 Thread Jeremy Burns | Class Outfit
There is an example here (http://book.cakephp.org/view/1030/Complex-Find-Conditions) that shows how to do a MIN query, which is essentially the same thing. Jeremy Burns Class Outfit jeremybu...@classoutfit.com http://www.classoutfit.com On 9 Aug 2010, at 10:09, Cruisine wrote: hi i'm still

Re: how to make sum query on cake ?

2010-08-09 Thread Cruisine
tq for ur answer. but i couldnt found any statement that explaining about how to sum a field in query on cakephp.. so..any idea? On Aug 9, 4:23 pm, Jeremy Burns | Class Outfit jeremybu...@classoutfit.com wrote: There is an example here

Re: how to make sum query on cake ?

2010-08-09 Thread Jeremy Burns | Class Outfit
Follow the MIN example, and replace the MIN with SUM. Jeremy Burns Class Outfit jeremybu...@classoutfit.com http://www.classoutfit.com On 9 Aug 2010, at 10:34, Cruisine wrote: tq for ur answer. but i couldnt found any statement that explaining about how to sum a field in query on cakephp..