|Subject:||Weird query pagination|
|Date:||Fri, 4 Feb 2011 09:36:52 -0800 PST|
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>|
|Previous by Date:||Re: Multilingual Support in cakePHP, cricket|
|Next by Date:||Re: how to get validation messages next to text field?, Andras Kende|
|Previous by Thread:||Cannot get Auth component loginAction to work, WhyNotSmile|
|Next by Thread:||Re: Weird query pagination, cricket|
|Indexes:||[Date] [Thread] [Top] [All Lists]|