[email protected]
[Top] [All Lists]

Weird query pagination

Subject: Weird query pagination
From: Dee Johnson
Date: Fri, 4 Feb 2011 09:36:52 -0800 PST
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?

$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
[email protected] For more options, visit this group at http://groups.google.com/group/cake-php
<Prev in Thread] Current Thread [Next in Thread>