Re: HABTM again!

2011-07-21 Thread gremlin
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

Re: HABTM again!

2011-07-21 Thread Jeremy Burns | Class Outfit
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 > > > c

Re: HABTM again!

2011-07-21 Thread localhost
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', '

Re: HABTM again!

2011-07-21 Thread localhost
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', 'cond

Re: HABTM again!

2011-07-21 Thread Jeremy Burns | Class Outfit
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 ho

HABTM again!

2011-07-21 Thread localhost
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

RE: HABTM... again

2011-03-02 Thread Krissy Masters
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 (

HABTM... again

2011-03-02 Thread János Vasbányai
Hello! I'm trying to get some data using habtm. here is the code: $this->Article->bindModel(array('hasOne'=>array('ArticlesTag'))); $tags = $this->Article->Tag- >find('list',array('conditions'=>array('ArticlesTag.article_id'=> $id))); The source is from the manual. Now the error: Warning (512):

Re: Habtm again

2010-04-02 Thread WebbedIT
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://cake

Habtm again

2010-04-01 Thread Mateusz Kaczanowski
Hi guys, I have a little annoying problem. Habtm declaration: 'ParentsHasStudents' => array( 'className' => 'Parents', 'joinTable' => 'parents_has_students', 'foreignKey' => 'parent_id', 'unique' => false, 'associationForeignKey' => 'student_id')); And Post Data: [ParentsHasStudents] => Arr

HABTM again

2008-10-23 Thread cem
How can I get the related data in habtm in paginator . I have auctions and categories . One auction HABTM category . I want to get the auctions which has category with ID : $data = $this->paginate('Project' ,array( 'Auction.statu