Check the Containable behavior. Helped me alot when I was dealing with complex relations on different depths.
http://book.cakephp.org/view/474/Containable justclint pisze: > Im pulling the data successfully but Im trying to get the "name" value > as opposed to the "id" value in a separate table. > > When I do debug I get this: > ( > [Product] => Array > ( > [id] => 21 > [color_id] => 3 > [image_thumb] => aw_ls_black.png > [price] => 27.95 > [shipping_price] => 5.00 > [style_id] => 1 > ) > > [Style] => Array > ( > [id] => 1 > [name] => All Weather Longsleeve Compression Shirt > [gender_id] => 2 > [category_id] => 2 > [material_id] => 2 > [application_id] => 2 > > > For sake of example I will just reference the gender_id. I need it to > show the name not the id. > > I have the following tables/models. > > Products > Styles > Genders > > Product Model: > class Product extends AppModel { > > var $name = 'Product'; > > var $belongsTo = array( > 'Style' => array( > 'className' => 'Style', > 'foreignKey' => 'style_id', > 'conditions' => '', > 'fields' => '', > 'order' => '' > ), > ); > > } > > Styles Model: > class Style extends AppModel { > > var $name = 'Style'; > > var $belongsTo = array( > 'Gender' => array( > 'className' => 'Gender', > 'foreignKey' => 'gender_id', > 'conditions' => '', > 'fields' => '', > 'order' => '' > ), > 'Category' => array( > 'className' => 'Category', > 'foreignKey' => 'category_id', > 'conditions' => '', > 'fields' => '', > 'order' => '' > ), > 'Material' => array( > 'className' => 'Material', > 'foreignKey' => 'material_id', > 'conditions' => '', > 'fields' => '', > 'order' => '' > ), > 'Application' => array( > 'className' => 'Application', > 'foreignKey' => 'application_id', > 'conditions' => '', > 'fields' => '', > 'order' => '' > ) > ); > > } > > Gender Model: > var $name = 'Gender'; > > var $hasMany = array( > > 'Style' => array( > 'className' => 'Style', > 'foreignKey' => 'gender_id', > 'dependent' => false, > 'conditions' => '', > 'fields' => '', > 'order' => '', > 'limit' => '', > 'offset' => '', > 'exclusive' => '', > 'finderQuery' => '', > 'counterQuery' => '' > ) > ); > > } > ?> > > The page im trying to get this on is my product view page. Action > looks like this: > > function view($id = null) { > if (!$id) { > $this->Session->setFlash(__('Invalid Product.', true)); > $this->redirect(array('action'=>'index')); > } > > $this->set('product', $this->Product->read(null, $id)); > } > > Ive been playing with this for hours and I just cant seem to get it. > > If you need more info, please dont hesitate to ask. > > Your help is greatly appreciated. > > Thanks! > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
