Am 22.04.2012 20:24, schrieb kdubya:
> [...]
> This can be written as a find():
> $total = $this->CustomerPurchases->find('first',
> array('conditions'=>array('customerbill_id'=>$billid),
> 'fields'=>array('sum(customerpurchases.amount) as total'));
I think something like
$total = $this->CustomerPurchases->field('SUM(amount)',
array('customerbill_id' => $billid));
should do the trick
--
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
