I also tried HABTM with the same result, I can't retrieve the data that I need. But as fas as I know there is no big difference between hasMany through (Join Model) and HABTM. I'll be glad if you help me correctly retrieve my data with conditions I posted in the first message, no matter if you choose HABTM or Join Model (I know how to setup both of them).
On Monday, September 17, 2012 6:35:18 AM UTC+4, jsundquist wrote: > > Why are you using a hasMany instead of a hasAndBelongsToMany? You wouldn't > need the id column as you two ideas together would be your index. > > - "The cold winds are rising" > On Sep 16, 2012 5:17 PM, "Nvp" <[email protected] <javascript:>> wrote: > >> Hi! >> I built DB with tables: >> >> *restaurants* - main table >> >> *kitchens* - second table >> >> *kitchen_restaurants* - join table with fields: id, kitchen_id, >> restaurant_id >> >> *Model/Restaurant.php*: >> public $hasMany = array( >> 'KitchenRestaurant' >> ); >> >> *Model/Kitchen.php*: >> public $hasMany = array( >> 'KitchenRestaurant' >> ); >> >> *Model/KitchenRestaurant.php*: >> public $belongsTo = array( >> 'Restaurant', 'Kitchen' >> ); >> >> The problem is that I have separate controller for my main page in which >> I need to retrieve data from this models with complex conditions. >> >> I added >> >> public $uses = array('Restaurant'); >> >> to my main page controller and here comes the part where I need your >> advices. >> >> I need to select only those restaurants where kitchen = $id. I've tried >> to add >> public function index() { >> $this->set('rests', $this->Restaurant->find('all', array( 'conditions' => >> array('Restaurant.active' => "1", 'KitchenRestaurant.id' => "1") ))); } >> >> but I get Column not found error. How to properly retrieve data >> in hasMany through or HABTM? >> Thanks! >> >> -- >> Like Us on FacekBook https://www.facebook.com/CakePHP >> Find us on Twitter http://twitter.com/CakePHP >> >> --- >> You received this message because you are subscribed to the Google Groups >> "CakePHP" group. >> To post to this group, send email to [email protected]<javascript:> >> . >> To unsubscribe from this group, send email to >> [email protected] <javascript:>. >> Visit this group at http://groups.google.com/group/cake-php?hl=en. >> >> >> > -- Like Us on FacekBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- 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]. Visit this group at http://groups.google.com/group/cake-php?hl=en.
