What do you mean by 'not shown'? Is it greyed out? You mention the
query gets more than 1 result - but does it get more than 1 page of
results? Can you show us the pagination code (for setup etc) from your
controller?
On Jul 21, 2:43 am, roby <[EMAIL PROTECTED]> wrote:
> Can someone tell me some possible reasons why the pagination link not
> shown in the view page?
>
> I've done some pagination with custom query (with sub query in it and
> do some aggregate query within the field list) and the query also
> success, the query i.e.:
>
> SELECT `Document`.`id`, `Document`.`status`, `Document`.`year`,
> `Document`.`semester`, `Course`.`id`, `Course`.`name`,
> `Course`.`major_id`, count( Document.id ) AS rev FROM `documents` AS
> `Document` LEFT JOIN `courses` AS `Course` ON (`Document`.`course_id`
> = `Course`.`id`) WHERE `Course`.`major_id` IN (1, 2, 3, 4) AND
> `Document`.`created_date` IN ('2008-07-20 20:42:49', '2008-07-20
> 21:17:36', '2008-07-20 21:27:00', '2008-07-20 21:27:00') AND 1 = 1
> GROUP BY `Document`.`id`, `Document`.`status`, `Document`.`year`,
> `Document`.`semester`, `Course`.`major_id`, `Course`.`id`,
> `Course`.`name` ORDER BY `Document`.`year` DESC, `Document`.`semester`
> DESC, `Course`.`major_id` ASC, `Document`.`status` ASC, `Course`.`id`
> ASC
>
> The weird thing is the paging link not shown but the query above
> definitely returns more than 1 rows (i.e. limit=1). If I change the
> pagination just for simple query (i.e. SELECT * FROM something), the
> pagination link is shown.
>
> Does everyone ever possess similar problem like this before? Could you
> tell me the possible reason that problem occurred?
>
> Thanks in advance.
> Roby
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
