| 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 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> |
|---|---|---|
| ||
| 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] |