cake-php@googlegroups.com
[Top] [All Lists]

Re: Weird query pagination

Subject: Re: Weird query pagination
From: cricket
Date: Fri, 4 Feb 2011 14:09:26 -0500
On Fri, Feb 4, 2011 at 12:36 PM, Dee Johnson <devariojay@xxxxxxxxx> wrote:
> Hi Bakers,
>
> I have something weird going on and i was wondering if you guys had come
> across this.  I am using the paginator class  and that works fine all
> through my site...but when i call the paginator class on this particular
> query it paginates the results in the view BUT when i click next it DOES NOT
> advance!  weird huh?  any ideas?

Do you mean the page doesn't re-load?What if you copy and paste the
link? Could it be a JS issue?

 Or is the page reloading but the same results are displayed? What
does the link look like?

What about if you debug($this->params)?


> $myquery = $this->paginate('Model', array("OR" => array('Model.field1 LIKE'
> => '%,' . $val . ',%', 'Model.field1 LIKE' => '' . $val . ',%',
> 'Model.field1 LIKE' => '%,' . $val)), array("NOT" => array('Model.field2' =>
> array('6', '10'))), array('Model.field3 !=' => '2'));
>
> The query is a bit bloated i know, but Im trying something here...let me
> know if there is a more efficient way or what could be causing this
> behavior.  Thanks!
>
> --
> 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@xxxxxxxxxxxxxxxx For more options, visit this group at
> http://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
cake-php+unsubscribe@xxxxxxxxxxxxxxxx For more options, visit this group at 
http://groups.google.com/group/cake-php

<Prev in Thread] Current Thread [Next in Thread>