Thanks for helping. I just tried and that is very strange. I don't get anymore SQL error but it doesn't work. I mean the filtering returns an empty array, while it should not. I checked and I'm 100% sure there should be some output after the filtering.
On Jun 20, 11:12 am, Tilen Majerle <[email protected]> wrote: > emm...try this > > $filter = array(); > $filter['Nationality.language_id LIKE'] = 2; > > -- > Lep pozdrav, Tilen Majerlehttp://majerle.eu > > 2011/6/20 thomaus <[email protected]> > > > > > > > > > Nobody no clue? > > > On Jun 17, 5:43 pm, thomaus <[email protected]> wrote: > > > Hi there, > > > > I am doing 2nd order pagination using Containable. It is working fine > > > but when I try to paginate with a 2nd order filter, it doesn't work > > > anymore. > > > > Here are my models relations : > > > > "Result" belongs to "Test" > > > "Test" belongs to "Nationality" > > > > Here is my code : > > > > $this->Result->recursive = 2; > > > $this->Result->Behaviors->attach('Containable'); > > > > $this->paginate = array( > > > 'limit' => 20, > > > 'contain' => array( > > > 'Test' => array( > > > 'Nationality' => array('fields' => array('language_id')) > > > ))); > > > > $filter = array(); > > > $filter['Test.Nationality.language_id LIKE'] = 2; > > > > $results = $this->paginate(null, $filter); > > > > and I get this error: > > > > SQL Error: 1054: Unknown column 'Test.Nationality.language_id' > > > > If I empty the filter array, I can access $result['Test'] > > > ['Nationality']['language_id'] from my view without any problem so the > > > pagination is working fine BUT the filtering is NOT. Why? > > > -- > > Our newest site for the community: CakePHP Video Tutorials > >http://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 > > [email protected] 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 [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
