What do you get if you set recursive to 3?
On Nov 18, 7:53 am, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
wrote:
> Hi, thanks for the reply =)
>
> don't see how that matters, but sure
>
> <?php
> class Person extends AppModel {
> var $name = 'Person';
> var $hasAndBelongsToMany = array('Picture');}
>
> ?>
>
> <?php
> class Picture extends AppModel {
> var $name = 'Picture';
> var $hasAndBelongsToMany = array('Person', 'Album');}
>
> ?>
>
> <?php
> class Album extends AppModel {
> var $name = 'Album';
> var $hasAndBelongsToMany = array('Picture');}
>
> ?>
>
> So a picture may be of more than one person, and each person appears
> on many pictures. Each picture may be on different albums, and each
> album has many pictures. I have the 3 tables for the models and the 2
> for the joins.
> Now, like I told you, when I find() the people with default recursion
> 1, I get a person and all the pictures associated with that person.
> When I find() with recursion 2, additionally I get each album of each
> picture, BUT NOT all the people associated with that picture again. So
> what I want is the 'sister' persons of a person, the ones that appear
> on the same picture, but I guess cake isn't doing this to avoid loops
> or something, which it clearly wouldn't.
>
> Help? =S
>
> On Nov 18, 1:11 am, the_woodsman <[EMAIL PROTECTED]> wrote:
>
> > You should look into/post your model relationships, there are some
> > relevant things in there...
>
> > On Nov 17, 3:41 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> > wrote:
>
> > > Hello
>
> > > I wonder if anyone can help me with a specific database design. I have
> > > a database with pictures of people. A person may be on different
> > > pictures, and a picture may have many people on it (so its a
> > > HasAndBelongsTo relation with 3 tables...)
>
> > > My problem is that, on a view of a person, I want to list all the
> > > pictures of that person, PLUS all other the people that show up in the
> > > same photo! So its hard because if try to find() this person with
> > > recursion 2, it will fetch the associated pictures, but not the
> > > people, since it already passed by the people table. So I'm getting
> > > something like this:
>
> > > Array
> > > (
> > > [Person] => Array
> > > (
> > > [id] => 1
> > > [name] => Bob
> > > )
> > > [Picture] => Array
> > > (
> > > [0] => Array
> > > (
> > > [id] => 114
> > > [description] => Oh what a nice picture
> > > )
> > > [1] => Array
> > > (
> > > [id] => 115
> > > [description] => Oh what a lovely picture
> > > )
> > > )
> > > )
>
> > > When actually I need something like this:
>
> > > Array
> > > (
> > > [Person] => Array
> > > (
> > > [id] => 1
> > > [name] => Bob
> > > )
> > > [Picture] => Array
> > > (
> > > [0] => Array
> > > (
> > > [id] => 114
> > > [description] => Oh what a nice picture
> > > [Person] => Array(
> > > [0] => Array (
> > > [id] => 2
> > > [name] => Alice
> > > )
> > > )
> > > (...) and so on
>
> > > has anyone come across such a problem? How can I get around it?
> > > Thank You
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
