Hi. I know it's been a while since this was posted, but did you get any solution on this matter?? I'm just struggeling with a similar problem and could only "find" your post on "dreamincode-dot-net". you'd rly help me alot if you could tell me how you solved it.
Am Mittwoch, 2. Februar 2011 09:45:46 UTC+1 schrieb KuroTsuto: > > Hey All, > > I'm working on a project wherein I would like to implement a model that > hasAndBelongsToMany of itself. To better illustrate this, imagine a data > structure composed of linking nodes not unlike that of a tree. Instead of > one parent and many child nodes, however, my structure has many parent > nodes and many child nodes. The sequence of the nodes is still important > (i.e. I still require a separation of children and parents). I would like > to retain the ability to transverse the structure by traveling to any > parent or any child from the node at which I currently sit, and so I > believe HABTM relationships to be the answer. > > My attempt to solve this conundrum was to implement a node table and two > join tables - children and parents - both of which taking the place of what > would be conventionally named nodes_nodes tables. The "children" join table > consists of two columns - 'node_id' and 'child_id' - as does the "parents" > join table - 'node_id' and 'parent_id'. > > And so my Node model holds the HABTM associations > > 'Child' => array( > 'className' => 'Node', > 'joinTable' => 'children', > 'foreignKey' => 'node_id', > 'associationForeignKey' => 'child_id' > > ) , > > 'Parent' => array( > > 'className' => 'Node', > > 'joinTable' => 'parents', > > 'foreignKey' => 'node_id', > > 'associationForeignKey' => 'parent_id' > > ) > > > This approach has got me far as the Bake utility generating controllers > and views that provide the option to select multiple Nodes as parents and > children while adding or updating, however the selected parent/children are > not actually inserted into the join tables. > > And so I ask: am I going about this in the right manner? If not, or if you > have an alternate suggestion - I'm all ears! Please point me in the correct > direction :) > > Thank you very much for your time and consideration, > ~KuroTstuo > -- Like Us on FaceBook 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 unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/d/optout.