How to use sql functions in conditions
http://cakebaker.42dh.com/2007/05/04/how-to-use-sql-functions-in-conditions/
On May 18, 8:45 am, Enchy <[EMAIL PROTECTED]> wrote:
> var $belongsTo = array( 'Orderitem' =>
> array('className' => 'Orderitem',
> 'conditions' => '',
> 'order' => 'item ASC',
> 'limit' => '',
> 'foreignKey' => 'id',
> 'dependent' => true,
> 'exclusive' => false,
> 'finderQuery' => ' '
> )
>
> );
>
> Hi I cant find this anywhere. how do you add a custom query after
> SELECT statement.
> I just want to add SUM()price as totalprice
>
> 'finderQuery' => 'SELECT item,price,quantity,SUM(price) as
> oidPrice FROM Orderitems '
> I tried this but it just executes it without the finder. How do you
> include finder into this?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
