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