I have to say I'm pretty impressed with cakePHP so far.
I really didn't think this would work, but the fact that I just did
what seemed logical and it worked like a charm just made cake awesome
in my book.
So I did confirm that you can indeed HABTM to yourself.
I created a link table called "parts_parts" which has id, part_id,
subpart_id and qnty.
In the Part model I associated the table to itself.
var $hasAndBelongsToMany = array('Parts'=>
array('className' => 'Part',
'joinTable' => 'parts_parts',
'foreignKey' => 'part_id',
'associationForeignKey' => 'subpart_id' ));
And it just worked! If I get a part, it also automatically gets all
it's sub parts linked in the parts_parts table.
Thanks cakePHP!
On Apr 23, 4:38 pm, turbo2ltr <[email protected]> wrote:
> I have "Parts" which has a type. The type can be a part or an
> assembly.
>
> A part is just that, a single part, whereas a part that's has a type
> of assembly is a collection of parts and/or other assemblies. So I
> need a table to link one records in Parts to one or more other records
> in the same Parts table.
>
> I have AssyData which is a link table which has part_id and
> assy_part_id. The problem is the table links two ID's in the same
> Parts table. All the docs and tutorials seem to assume you are
> linking two different tables. Can CakePHP handle that or will I have
> to have a table for Parts and a separate table for Assemblies, then
> have the link table link those two tables?
>
> Thanks,
> Mike
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
