Not sure if this would work (and I haven't tried it) but have a go at adjusting
this syntax:
array('fields'=>array('Product.type','MIN(Product.price) as price'), 'group' =>
'Product.type');
As you can see, 'MIN(Product.price) as price' is just a function that gets
passed through to the SQL and evaluated - you might be able to use that?
Jeremy Burns
Class Outfit
[email protected]
http://www.classoutfit.com
On 30 Mar 2011, at 08:00, thom wrote:
> Hello, I just wonder about how to write Mysql's syntax SUM IF in
> Cakephp. Is there a way to insert it in 'cake-way' or just using
> this->query() ??
>
> Thank you very much.
>
> --
> Regards,,,
> mastanto
> http://www.mastanto.com
> http://thom-sharing.blogspot.com
>
> --
> Our newest site for the community: CakePHP Video Tutorials
> http://tv.cakephp.org
> Check out the new CakePHP Questions site http://ask.cakephp.org and help
> others with their CakePHP related questions.
>
>
> To unsubscribe from this group, send email to
> [email protected] For more options, visit this group at
> http://groups.google.com/group/cake-php
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
