Re: HABTM again!
If you have defined a HABTM relationship your joining table should be links_users (i.e. the tables are in alphabetical order). Jeremy Burns Class Outfit http://www.classoutfit.com On 21 Jul 2011, at 16:26, localhost wrote: Hi everyone, I have being trying to solve this for the last 4 hours with no luck. basically I have the following tables users links users_links Basically I'm trying to get the below query to run using find('all') and paginate (I'm running this inside UserController) SELECT Links.id,Links.Title FROM users,links,users_links WHERE user.id=1 AND user.id=users_links.user_id AND users_links.link_id=links.id AND users_links.index=1 (see the above sql users_links.index=1). how to get this working ? -- 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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php -- 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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: HABTM again!
Sorry I didn't understand your reply I have defined the relationship class UsersLink extends AppModel { var $belongsTo = array( 'Link' = array( 'className' = 'Link', 'foreignKey' = 'link_id', 'conditions' = '', 'fields' = '', 'order' = '' ), 'User' = array( 'className' = 'User', 'foreignKey' = 'user_id', 'conditions' = '', 'fields' = '', 'order' = '' ) ); } What do you mean by joining table should be links_users (i.e. the tables are in alphabetical order) ? On Jul 21, 6:31 pm, Jeremy Burns | Class Outfit jeremybu...@classoutfit.com wrote: If you have defined a HABTM relationship your joining table should be links_users (i.e. the tables are in alphabetical order). Jeremy Burns Class Outfit http://www.classoutfit.com On 21 Jul 2011, at 16:26, localhost wrote: Hi everyone, I have being trying to solve this for the last 4 hours with no luck. basically I have the following tables users links users_links Basically I'm trying to get the below query to run using find('all') and paginate (I'm running this inside UserController) SELECT Links.id,Links.Title FROM users,links,users_links WHERE user.id=1 AND user.id=users_links.user_id AND users_links.link_id=links.id AND users_links.index=1 (see the above sql users_links.index=1). how to get this working ? -- Our newest site for the community: CakePHP Video Tutorialshttp://tv.cakephp.org Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group athttp://groups.google.com/group/cake-php -- 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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: HABTM again!
This is one way I found it to be working with find('all') but not with paginate ( due to the select count) $this-User-recursive = -1; $options['joins'] = array( array('table' = 'users_links', 'alias' = 'UsersLink', 'type' = 'inner', 'conditions' = array( 'User.id = UsersLink.user_id', 'UsersLink.inbox = 1' ) ), array('table' = 'links', 'alias' = 'Link', 'type' = 'inner', 'conditions' = array( 'UsersLink.link_id = Link.id' ) ) ); $options['fields' ] = array('Link.id', 'Link.title'); $inbox = $this-User-find('all', $options); What do you think? On Jul 21, 6:31 pm, Jeremy Burns | Class Outfit jeremybu...@classoutfit.com wrote: If you have defined a HABTM relationship your joining table should be links_users (i.e. the tables are in alphabetical order). Jeremy Burns Class Outfit http://www.classoutfit.com On 21 Jul 2011, at 16:26, localhost wrote: Hi everyone, I have being trying to solve this for the last 4 hours with no luck. basically I have the following tables users links users_links Basically I'm trying to get the below query to run using find('all') and paginate (I'm running this inside UserController) SELECT Links.id,Links.Title FROM users,links,users_links WHERE user.id=1 AND user.id=users_links.user_id AND users_links.link_id=links.id AND users_links.index=1 (see the above sql users_links.index=1). how to get this working ? -- Our newest site for the community: CakePHP Video Tutorialshttp://tv.cakephp.org Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group athttp://groups.google.com/group/cake-php -- 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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: HABTM again!
I think you are not following the conventions, are making life difficult for yourself and should read the guide. Jeremy Burns Class Outfit http://www.classoutfit.com On 21 Jul 2011, at 17:05, localhost wrote: Sorry I didn't understand your reply I have defined the relationship class UsersLink extends AppModel { var $belongsTo = array( 'Link' = array( 'className' = 'Link', 'foreignKey' = 'link_id', 'conditions' = '', 'fields' = '', 'order' = '' ), 'User' = array( 'className' = 'User', 'foreignKey' = 'user_id', 'conditions' = '', 'fields' = '', 'order' = '' ) ); } What do you mean by joining table should be links_users (i.e. the tables are in alphabetical order) ? On Jul 21, 6:31 pm, Jeremy Burns | Class Outfit jeremybu...@classoutfit.com wrote: If you have defined a HABTM relationship your joining table should be links_users (i.e. the tables are in alphabetical order). Jeremy Burns Class Outfit http://www.classoutfit.com On 21 Jul 2011, at 16:26, localhost wrote: Hi everyone, I have being trying to solve this for the last 4 hours with no luck. basically I have the following tables users links users_links Basically I'm trying to get the below query to run using find('all') and paginate (I'm running this inside UserController) SELECT Links.id,Links.Title FROM users,links,users_links WHERE user.id=1 AND user.id=users_links.user_id AND users_links.link_id=links.id AND users_links.index=1 (see the above sql users_links.index=1). how to get this working ? -- Our newest site for the community: CakePHP Video Tutorialshttp://tv.cakephp.org Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group athttp://groups.google.com/group/cake-php -- 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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php -- 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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: HABTM again!
What is being said is that you have some conventions you didn't follow. As a result, you are writing overly-complicated code to handle what should be automatic within the framework. Do this: 1) move / rename your users_links table and data to a links_users table inside mysql. 2) remove completely the model for your join table - the UsersLink model. 3) define a normal habtm relationship between the User model and the Link model. 4) read the manual before you start another project - all of this is clearly explained in many translations. On Jul 21, 10:45 am, Jeremy Burns | Class Outfit jeremybu...@classoutfit.com wrote: I think you are not following the conventions, are making life difficult for yourself and should read the guide. Jeremy Burns Class Outfit http://www.classoutfit.com On 21 Jul 2011, at 17:05, localhost wrote: Sorry I didn't understand your reply I have defined the relationship class UsersLink extends AppModel { var $belongsTo = array( 'Link' = array( 'className' = 'Link', 'foreignKey' = 'link_id', 'conditions' = '', 'fields' = '', 'order' = '' ), 'User' = array( 'className' = 'User', 'foreignKey' = 'user_id', 'conditions' = '', 'fields' = '', 'order' = '' ) ); } What do you mean by joining table should be links_users (i.e. the tables are in alphabetical order) ? On Jul 21, 6:31 pm, Jeremy Burns | Class Outfit jeremybu...@classoutfit.com wrote: If you have defined a HABTM relationship your joining table should be links_users (i.e. the tables are in alphabetical order). Jeremy Burns Class Outfit http://www.classoutfit.com On 21 Jul 2011, at 16:26, localhost wrote: Hi everyone, I have being trying to solve this for the last 4 hours with no luck. basically I have the following tables users links users_links Basically I'm trying to get the below query to run using find('all') and paginate (I'm running this inside UserController) SELECT Links.id,Links.Title FROM users,links,users_links WHERE user.id=1 AND user.id=users_links.user_id AND users_links.link_id=links.id AND users_links.index=1 (see the above sql users_links.index=1). how to get this working ? -- Our newest site for the community: CakePHP Video Tutorialshttp://tv.cakephp.org Check out the new CakePHP Questions sitehttp://ask.cakephp.organdhelp others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group athttp://groups.google.com/group/cake-php -- Our newest site for the community: CakePHP Video Tutorialshttp://tv.cakephp.org Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group athttp://groups.google.com/group/cake-php -- 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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
RE: HABTM... again
For 1.2 but still applies: http://marianoiglesias.com.ar/cakephp/modelizing-habtm-join-tables-in-cakeph p-1-2-with-and-auto-with-models/ or http://nuts-and-bolts-of-cakephp.com/2008/07/03/notes-on-cakephp-habtm-part- 1-the-basics/ Common mistake is in the name. Filename / classname / singular (plural mixup). Also with = some_join_table parameter another option. K -- 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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Habtm again
Which model are you declaring this in? As it should logically be in Parent or Student, but your controller logic looks as though you're in Person. Until I can understand a little more about your models I cant really offer much assistance. Paul Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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 To unsubscribe, reply using remove me as the subject.