I wonder how I could make a simple query to work through bind(), and not use a custom query.
I'm binding two models for a model: $this->Ticket->bindModel(array('belongsTo' => array('Deal' => array('foreignKey' => 'deal_id')))); $this->Ticket->bindModel(array('belongsTo' => array('Item' => array('foreignKey' => 'deal_id')))); The resulting query I get is this: SELECT `Ticket`.`id`, `Deal`.`file`, `Item`.`title` FROM `tickets` AS `Ticket` LEFT JOIN `deals` AS `Deal` ON (`Ticket`.`deal_id` = `Deal`.`id`) LEFT JOIN `items` AS `Item` ON (`Ticket`.`deal_id` = `Item`.`id`) WHERE `Ticket`.`user_id` = 1 Now, instead of: `Item` ON (`Ticket`.`deal_id` = `Item`.`id`) I need: `Item` ON (`Deal`.`item_id` = `Item`.`id`) Which gives this query: SELECT `Ticket`.`id`, `Deal`.`file`, `Item`.`title` FROM `tickets` AS `Ticket` LEFT JOIN `deals` AS `Deal` ON (`Ticket`.`deal_id` = `Deal`.`id`) LEFT JOIN `items` AS `Item` ON (`Deal`.`item_id` = `Item`.`id`) WHERE `Ticket`.`user_id` = 1 I tried binding item to deal, and CakePHP made 200 queries instead. That didn't work too well. Any ideas how I could make a slim query with CakePHP, without using query()? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---