Hey,
Try the containable behaviour. It is designed specifically to filter
out related results ("Feeds" in your case).
On Feb 7, 3:48 am, Joseph Buarao <[email protected]> wrote:
> Hello Guys,
>
> Thanks for your help Guys, I have fixed the limit statement but still
> in problem, I think I found the problem not in my query it is in my
> data structure, I was trying to paginate the data in one category,
> here's my data structure
> Array
> (
> [0] => Array
> (
> [Category] => Array
> (
> [id] => 1
> [name] =>
> [slug] => asian-food
> )
>
> [Feed] => Array
> (
> [0] => Array
> (
> [id] => 1
> [url] =>http://steamykitchen.com/blog/feed
> [title] =>
> [popularity] => 7
> [error] => 0
> [ParseItem] => Array
> (
> [0] => Array
> (
> [id] => 796
> [feed_id] => 1
> [datetime] => 2011-01-28
> 11:12:42
> [permalink]
> =>http://feedproxy.google.com/~r/SteamyKitchen/~3/Jh82Omii8DQ/13565-chi...
> [title] => Smoky Sweet
> Spicy Chipotle Cinnamon Wings
> [excerpt] =>
> )
>
> [1] => Array
> (
> [id] => 121
> [feed_id] => 1
> [datetime] => 2011-01-28
> 11:12:42
> [permalink]
> =>http://feedproxy.google.com/~r/SteamyKitchen/~3/Jh82Omii8DQ/13565-chi...
> [title] => Smoky Sweet
> Spicy Chipotle Cinnamon Wings
> [excerpt] =>
> )
>
> )
>
> )
>
> [1] => Array
> (
> [id] => 3
> [url]
> =>http://stickyrice.typepad.com/my_weblog/atom.xml
> [title] =>
> [popularity] => 8
> [error] => 0
> [ParseItem] => Array
> (
> [0] => Array
> (
> [id] => 127
> [feed_id] => 3
> [datetime] => 2011-01-19
> 04:58:22
> [permalink]
> =>http://stickyrice.typepad.com/my_weblog/2011/01/deck-of-the-fisherman...
> [title] => Deck of the
> Fisherman
> [excerpt] => Whenever I
> come
> )
> )
>
> as you can see here. there is only one category and inside of it
> there's a lot of feeds, that's why the paginate helper on cakephp did
> come out because it start counting, referring to limit in category not
> in the feeds, can you suggest to me guys how can I fix this. I want
> the limit statement working on the feeds not in category, because
> obviously it only has one category, so I want to limit the feeds
> result inside of that particular category and have a pagination..
> Thank you in advance again guys for you help..
>
> Joseph Buarao
> Web Developer
> Azure Web Design
>
> On Feb 6, 4:15 am, Jeremy Burns | Class Outfit
>
>
>
>
>
>
>
> <[email protected]> wrote:
> > It's 'limit' not 'limits'. Not sure if that's the only problem, but it's a
> > starter.
>
> > Jeremy Burns
> > Class Outfit
>
> > [email protected]http://www.classoutfit.com
>
> > On 5 Feb 2011, at 07:48, Joseph Buarao wrote:
>
> > > Hi Fellow Programmer,
>
> > > I getting problem with my code, I don't know what's the reason why the
> > > sql limit statement is not working on my paginate query. below are my
> > > codes feel free to suggest, I really Appreciated it.. Thank you in
> > > advance for your support GUYS...
>
> > > $this->paginate = array('conditions' => array('Category.slug'=>
> > > $category),
> > > 'limits' => 10);
>
> > > $feeds_data = $this->paginate('Category');
>
> > > By the way, I used hasAndBelongsToMany relationship..
>
> > > Thanks..
>
> > > Joseph Buarao
> > > Web Developer
> > > Azure Web Design.com
>
> > > --
> > > Our newest site for the community: CakePHP Video
> > > Tutorialshttp://tv.cakephp.org
> > > Check out the new CakePHP Questions sitehttp://ask.cakephp.organdhelp
> > > 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
