Contain HABTM
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
Excuse me, but pliz add some details, we are not sorcerers. On 5 ago, 14:58, Dave Maharaj :: WidePixels.com d...@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
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
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
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 bally.z...@gmail.com 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 d...@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 richardath...@gmail.com 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 bally.z...@gmail.com 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 d...@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
'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 richardath...@gmail.com 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 bally.z...@gmail.com 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 d...@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 richardath...@gmail.com 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 bally.z...@gmail.com 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 d...@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 -~--~~~~--~~--~--~---
contain HABTM
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 d...@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 -~--~~~~--~~--~--~---