Re: Plain SQL query in Pagination

2011-01-24 Thread cricket
On Mon, Jan 24, 2011 at 5:04 PM, mmamedov wrote: > cricket, > It's not about just 'union'. I don't want to be dealing with cakephp > style quering here. I am talking about plain sql query. Passing a pure > mysql query into pagination. As I said, 'union' was an arbitrary key. I chose it because yo

Re: Plain SQL query in Pagination

2011-01-24 Thread mmamedov
cricket, It's not about just 'union'. I don't want to be dealing with cakephp style quering here. I am talking about plain sql query. Passing a pure mysql query into pagination. I did it, and it worked. The problem however is when I am trying to go with reqular CakePHP pagination within the same co

Re: Plain SQL query in Pagination

2011-01-23 Thread cricket
On Sun, Jan 23, 2011 at 11:16 AM, mmamedov wrote: > OK. This is getting weird. > Now it works for custom query, but it doesn't work when I need default > pagination for other actions of the same controller. > > The problem is however, with the overriding paginate() and > paginateCount() - Cake 1.3

Re: Plain SQL query in Pagination

2011-01-23 Thread mmamedov
OK. This is getting weird. Now it works for custom query, but it doesn't work when I need default pagination for other actions of the same controller. The problem is however, with the overriding paginate() and paginateCount() - Cake 1.3 manual and the source code of both, are different. In Cake m

Re: Plain SQL query in Pagination

2011-01-23 Thread cricket
On Sat, Jan 22, 2011 at 11:52 PM, mmamedov wrote: > OK I did it. Just to clarify one thing: In my example, the value of the array that's passed for $scope is irrelevant. The important thing is to check if the 'union' key is set in $conditions. But, if you need to pass any data keep in mind that t

Re: Plain SQL query in Pagination

2011-01-22 Thread mmamedov
OK I did it. On Jan 22, 9:00 pm, mmamedov wrote: > Could you elaborate on that. I tried a few things with no luck. > > On Jan 22, 7:30 pm, cricket wrote: > > > On Sat, Jan 22, 2011 at 7:47 PM, mmamedov wrote: > > > I need to run this query in $this->paginate(). 99 is an arbitrary user > > > id

Re: Plain SQL query in Pagination

2011-01-22 Thread mmamedov
Could you elaborate on that. I tried a few things with no luck. On Jan 22, 7:30 pm, cricket wrote: > On Sat, Jan 22, 2011 at 7:47 PM, mmamedov wrote: > > I need to run this query in $this->paginate(). 99 is an arbitrary user > > id number that is externally provided. > > > I read this, http:boo

Re: Plain SQL query in Pagination

2011-01-22 Thread cricket
On Sat, Jan 22, 2011 at 7:47 PM, mmamedov wrote: > I need to run this query in $this->paginate(). 99 is an arbitrary user > id number that is externally provided. > > I read this, http:book.cakephp.org/view/249/Custom-Query-Pagination, > but it didn't help. I did also read this http:www.littlehart

Plain SQL query in Pagination

2011-01-22 Thread mmamedov
I need to run this query in $this->paginate(). 99 is an arbitrary user id number that is externally provided. I read this, http:book.cakephp.org/view/249/Custom-Query-Pagination, but it didn't help. I did also read this http:www.littlehart.net/ atthekeyboard/2008/03/04/custom-cakephp-12-pagination