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
-~----------~----~----~----~------~----~------~--~---

Reply via email to