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