Re: habtm

HI

you can solve this problem usign "custom query pagination".

you can search in google you will get many examples.


 

On Fri, Jun 24, 2011 at 10:02 PM, Prabha Vathi <prabha.riddles@gmail.com> wrote:

Hi,

In tagscontroller,
$this->paginate = array('conditions' => array('Post.status' => 'active','Tag.tag_machine_value' => $name),'limit' => 3);
$posts = $this->paginate('Post');
$this->set(compact('posts'));

Tag and Post model have hasAndBelongsToMany relation.

I am getting Unknown column 'Tag.tag_machine_value' in 'where clause'

I tried
$this->Tag->unBindModel(array('hasAndBelongsToMany' => array('Post')));
$this->Tag->bindModel(array('hasMany' => array('Post')));

But it is still not 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+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php

--
Master Ram.
Founder n Director of rgPlanets Pvt. Ltd.

--
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+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php