Re: self-recursive models
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 cake-php@googlegroups.com
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
-~--~~~~--~~--~--~---
Re: self-recursive models
I just get the same, as there are no more models associated =(
On Nov 18, 10:00 am, grigri [EMAIL PROTECTED] wrote:
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 cake-php@googlegroups.com
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
-~--~~~~--~~--~--~---
self-recursive models
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 cake-php@googlegroups.com 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 -~--~~~~--~~--~--~---
Re: self-recursive models
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 cake-php@googlegroups.com 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 -~--~~~~--~~--~--~---
Re: self-recursive models
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 cake-php@googlegroups.com
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
-~--~~~~--~~--~--~---
