Thanks, but it doesn't work. Gives me this query: SELECT `Module`.`id`, `Module`.`position`, `Module`.`name`, `Module`.`created`, `Module`.`modified` FROM `modules` AS `Module` WHERE `Version`.`name` = 'covermount'
and this error: 1054: Unknown column 'Version.name' in 'where clause' On 3 Jul., 20:14, brian <[email protected]> wrote: > Something like this? > > $modules = $this->Product->Module->find( > 'all', > array( > 'conditions' => array( > 'Version.name' => $version > ), > 'contain' => array( > 'Version' => array( > 'fields' => array('*') > ) > ) > ) > ); > > On Fri, Jul 3, 2009 at 6:00 AM, Andreas Derksen<[email protected]> > wrote: > > Hi all, > > i got some problems with my habtm containable setup. This is it: > > > Product HABTM Module > > Module HABTM Version > > > in the Product controller i want to find all modules that belong to an > > certain version defined in the Version model. > > > this was my approach: > > $this->Product->id = $id; > > $this->Product->find('first', array('contain' => array('Module' => > > array('conditions' => array('Version.name' => $version))))); > > > but it says: > > > Unknown column 'Version.name' in 'where clause' > > > how do i query it with or without the Containable behavior? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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 -~----------~----~----~----~------~----~------~--~---
