Re: Weird query pagination

On Fri, Feb 4, 2011 at 12:36 PM, Dee Johnson <devariojay@gmail.com> 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@googlegroups.com 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@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php