Hi Sricharan,
You haven't given enough information for us to be able to help you.
Without knowing more about your models, joins, queries, parameters and
data in the database we would be making guesses as to where your
problem lies.
The only thing I can say is it does not look as though you are us
In this case just use plain SQL in paginate() and paginateCount().
On Aug 31, 9:52 pm, Dean C wrote:
> Hi folks,
>
> I can't use a View for the union query as it requires parameters. Even
> if I take away the fulltext, and then do a fulltext search on the
> view, MySQL can't then delegate the in
Hi folks,
I can't use a View for the union query as it requires parameters. Even
if I take away the fulltext, and then do a fulltext search on the
view, MySQL can't then delegate the indexes across the union within
the view, so it doesn't work. Any more ideas or sample pieces of code
would be app
Hi,
This is haw I paginate and it works OK,
I have 3 join tables ( I can set different type of joins ),
Did you understand what is happening ?
function MyFunctionThatReturnPaginateArrayInfo {
code code code
...
return array(
'MortgageDetail' => array(
If you can do view for your union query you will be able to work with
it as with normal table.
On Aug 28, 5:58 am, Dean C wrote:
> Hi folks,
>
> Before I begin, yes I've read this
> page:http://book.cakephp.org/view/249/Custom-Query-Pagination
>
> I've also read many of the other pages on Googl
I also found that the group by value was correct for some paginate
calls and what I needed was the effected rows, I modified the
paginateCount method override as follows :-
function paginateCount($conditions = null, $recursive = 0, $extra = array()) {
$parameters = compact('conditions');
You need to override the pageCount() method with a custom count query,
for a similar type of query to yours I used the following method in my
model...
function paginateCount($conditions = null, $recursive = 0, $extra = array()) {
$parameters = compact('conditions');
$this->recursi
