P.S. franckyl, You were right, it does not work because there is no tag_id field in my story table.
On Jul 7, 10:58 am, inVINCable <[EMAIL PROTECTED]> wrote: > francky06I, > > I think a problem would occur because the variable depending on what > school_id is in their session, so if I put that in the finderQuery, > would that work? It return results based upon their school only ? I > was thinking about 'finderQuery' => 'where school_id = > $session->read(User.school_id)' Although I guess this will not work because > the > > model cannot be changed for every user that calls upon it? > > Thanks. > > On Jul 7, 10:49 am, francky06l <[EMAIL PROTECTED]> wrote: > > > I guess the hasOne relation does not work because you do not have a > > tag_id in your story table. The "link" can't be done at this level. > > You could use the finderQuery parameter, maybe into the HABTM > > association. > > This thread is very helpfull for the syntax of the finderQuery : > > >http://groups.google.com/group/cake-php/browse_thread/thread/5ac2bdec... > > > On Jul 7, 7:37 pm, inVINCable <[EMAIL PROTECTED]> wrote: > > > > Hi guys, > > > > Alright, this problem has troubled me for the past four hours so I > > > have to resort to the group : \ > > > > Ok, I have a HABTM between stories, tags, and my join table is > > > stories_tags. I have my search function set up very simply like this > > > in my tag controller > > > > function search($tag) { > > > $this->Story->Tag->findAllByTag($tag)); > > > > } > > > > The search works perfect fine, the only problem is it returns the > > > results from ALL the schools. An example of a return array of the tag > > > "computer" > > > > Array > > > ( > > > [0] => Array > > > ( > > > [Tag] => Array > > > ( > > > [id] => 30 > > > [tag] => Computer > > > ) > > > > [Story] => Array > > > ( > > > [0] => Array > > > ( > > > [id] => 117 > > > [title] => I went > > > [body] => to the store > > > [school_id] => 1 > > > [user_id] => 72 > > > [category_id] => > > > [agree] => > > > [disagree] => > > > [tags] => Computer > > > ) > > > > [1] => Array > > > ( > > > [id] => 118 > > > [title] => new > > > [body] => story > > > [school_id] => 3 > > > [user_id] => 72 > > > [category_id] => > > > [agree] => > > > [disagree] => > > > [tags] => Computer > > > ) > > > > ) > > > > Notice in the returned array in the stories there is a value > > > "school_id" My goal is when a user searches for the tag computer, only > > > the tags will show up relevant to their school. So this is what I have > > > been doing, but to no avail. I have been create a model on the fly, in > > > my tags controller, like so: > > > > this->Tag->bindModel( > > > array('hasOne' => array('Story'=> > > > array('className' => 'Story', > > > 'cinditions' => 'Story.school_id = 3') > > > > I must be doing something wrong though, so if anyone could offer any > > > tips as to what my bindModel should look like that would be great. > > > Thanks. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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 -~----------~----~----~----~------~----~------~--~---
