RE: Contain HABTM
Thanks,
I figured it out.
function __getAmenities ($id)
{
$params = array('conditions' => array('User.id' => $id),
'fields' =>
array('User.id'),
'contain' => array('Amenity'
=> array('UsersAmenities')));
$amenities = $this->find('first', $params);
return $amenities;
}
-Original Message-
From: pomares [mailto:k...@gordonpomarescentre.com]
Sent: August-05-09 9:16 PM
To: CakePHP
Subject: Re: Contain HABTM
What are the fields you want in your array?
--~--~-~--~~~---~--~~
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
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: Contain HABTM
What are the fields you want in your array? --~--~-~--~~~---~--~~ 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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Contain HABTM
Excuse me, but pliz add some details, we are not sorcerers. On 5 ago, 14:58, "Dave Maharaj :: WidePixels.com" wrote: > Is it possable to use contain to find HABTM data? > > I have > > Posts > Amenities > Posts_Amenities > > So I need a simple function to pull some user info and thier HABTM Amenities > > Dave --~--~-~--~~~---~--~~ 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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
RE: contain HABTM
'contain' => array(
'Subject' => array('fields' => array('Subject.name')),
The array looks like this
[Subject] => Array
(
[0] => Array
(
[name] => Political Science
[PostsSubject] => Array
(
[id] => 1
[post_id] => 1
[subject_id] => 1
)
)
What I do not need is anything in the PostsSubjects array and want to remove
that.
-Original Message-
From: Dave Maharaj :: WidePixels.com [mailto:d...@widepixels.com]
Sent: April-25-09 2:14 PM
To: cake-php@googlegroups.com
Subject: RE: contain HABTM
Sorry for the confusion.
The POST has about 10 other tables its related to but I do not want to pull
all that data associated with it. So I am trying to contain the tables I
needed and the fields.
-Original Message-
From: brian [mailto:bally.z...@gmail.com]
Sent: April-25-09 12:54 PM
To: cake-php@googlegroups.com
Subject: Re: contain HABTM
Yeah, I should have been more clear. I'm assuming that the Post info is
being fetched, also.
On Sat, Apr 25, 2009 at 3:54 AM, rich...@home
wrote:
>
> You don't need contain, unless you want the post data too:
>
> $this->Post->Subject->find("all", array(
> "conditions"=>array(
> "Subject.post_id"=>$post_id
> )
> );
>
> If you do need the post data, brian's solution should work just fine.
>
> On Apr 25, 5:21 am, brian wrote:
>> This doesn't work?
>>
>> $this->find(
>> 'first',
>> array(
>> 'conditions' => array(
>> 'Post.id' => $post_id
>> ),
>> 'contain' => array(
>> 'Subject'
>> )
>> )
>> );
>>
>> On Fri, Apr 24, 2009 at 11:30 PM, Dave Maharaj :: WidePixels.com
>>
>> wrote:
>> > Can someone help me with a contain using a HABTM relationship.
>> > POSTS HABTM SUBJECTS
>> > SUBJECTS
>> > POSTS_SUBJECTS
>>
>> > I have Post HABTM SUBECTS
>>
>> > I just want to print out the array of SUBJECTS that the POST has.
>>
>> > I managed to get the rest of the contain for the other hasmany
>> > tables...just cant get the HABTM
>>
>> > Thanks
>>
>> > Dave
> >
>
--~--~-~--~~~---~--~~
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
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
RE: contain HABTM
Sorry for the confusion.
The POST has about 10 other tables its related to but I do not want to pull
all that data associated with it. So I am trying to contain the tables I
needed and the fields.
-Original Message-
From: brian [mailto:bally.z...@gmail.com]
Sent: April-25-09 12:54 PM
To: cake-php@googlegroups.com
Subject: Re: contain HABTM
Yeah, I should have been more clear. I'm assuming that the Post info is
being fetched, also.
On Sat, Apr 25, 2009 at 3:54 AM, rich...@home
wrote:
>
> You don't need contain, unless you want the post data too:
>
> $this->Post->Subject->find("all", array(
> "conditions"=>array(
> "Subject.post_id"=>$post_id
> )
> );
>
> If you do need the post data, brian's solution should work just fine.
>
> On Apr 25, 5:21 am, brian wrote:
>> This doesn't work?
>>
>> $this->find(
>> 'first',
>> array(
>> 'conditions' => array(
>> 'Post.id' => $post_id
>> ),
>> 'contain' => array(
>> 'Subject'
>> )
>> )
>> );
>>
>> On Fri, Apr 24, 2009 at 11:30 PM, Dave Maharaj :: WidePixels.com
>>
>> wrote:
>> > Can someone help me with a contain using a HABTM relationship.
>> > POSTS HABTM SUBJECTS
>> > SUBJECTS
>> > POSTS_SUBJECTS
>>
>> > I have Post HABTM SUBECTS
>>
>> > I just want to print out the array of SUBJECTS that the POST has.
>>
>> > I managed to get the rest of the contain for the other hasmany
>> > tables...just cant get the HABTM
>>
>> > Thanks
>>
>> > Dave
> >
>
--~--~-~--~~~---~--~~
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
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: contain HABTM
Yeah, I should have been more clear. I'm assuming that the Post info
is being fetched, also.
On Sat, Apr 25, 2009 at 3:54 AM, rich...@home wrote:
>
> You don't need contain, unless you want the post data too:
>
> $this->Post->Subject->find("all", array(
> "conditions"=>array(
> "Subject.post_id"=>$post_id
> )
> );
>
> If you do need the post data, brian's solution should work just fine.
>
> On Apr 25, 5:21 am, brian wrote:
>> This doesn't work?
>>
>> $this->find(
>> 'first',
>> array(
>> 'conditions' => array(
>> 'Post.id' => $post_id
>> ),
>> 'contain' => array(
>> 'Subject'
>> )
>> )
>> );
>>
>> On Fri, Apr 24, 2009 at 11:30 PM, Dave Maharaj :: WidePixels.com
>>
>> wrote:
>> > Can someone help me with a contain using a HABTM relationship.
>> > POSTS HABTM SUBJECTS
>> > SUBJECTS
>> > POSTS_SUBJECTS
>>
>> > I have Post HABTM SUBECTS
>>
>> > I just want to print out the array of SUBJECTS that the POST has.
>>
>> > I managed to get the rest of the contain for the other hasmany
>> > tables...just
>> > cant get the HABTM
>>
>> > Thanks
>>
>> > Dave
> >
>
--~--~-~--~~~---~--~~
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
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: contain HABTM
You don't need contain, unless you want the post data too:
$this->Post->Subject->find("all", array(
"conditions"=>array(
"Subject.post_id"=>$post_id
)
);
If you do need the post data, brian's solution should work just fine.
On Apr 25, 5:21 am, brian wrote:
> This doesn't work?
>
> $this->find(
> 'first',
> array(
> 'conditions' => array(
> 'Post.id' => $post_id
> ),
> 'contain' => array(
> 'Subject'
> )
> )
> );
>
> On Fri, Apr 24, 2009 at 11:30 PM, Dave Maharaj :: WidePixels.com
>
> wrote:
> > Can someone help me with a contain using a HABTM relationship.
> > POSTS HABTM SUBJECTS
> > SUBJECTS
> > POSTS_SUBJECTS
>
> > I have Post HABTM SUBECTS
>
> > I just want to print out the array of SUBJECTS that the POST has.
>
> > I managed to get the rest of the contain for the other hasmany tables...just
> > cant get the HABTM
>
> > Thanks
>
> > Dave
--~--~-~--~~~---~--~~
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
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: contain HABTM
This doesn't work? $this->find( 'first', array( 'conditions' => array( 'Post.id' => $post_id ), 'contain' => array( 'Subject' ) ) ); On Fri, Apr 24, 2009 at 11:30 PM, Dave Maharaj :: WidePixels.com wrote: > Can someone help me with a contain using a HABTM relationship. > POSTS HABTM SUBJECTS > SUBJECTS > POSTS_SUBJECTS > > I have Post HABTM SUBECTS > > I just want to print out the array of SUBJECTS that the POST has. > > I managed to get the rest of the contain for the other hasmany tables...just > cant get the HABTM > > Thanks > > Dave > > > --~--~-~--~~~---~--~~ 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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
