In the Cake Book and the Cake api 'page' is listed as a possible option for find queries. Neither place really explains what that is. I assumed it would serve as a manual way of dealing with pagination. Since I couldn't figure out how to make the paginator work with my site's architecture, I was trying to use containable to limit/paginate for me. I thought if I had 'limit' => 10 and 'page' => 2 I'd get rows 11 -20. If that is the intent of the page option, it doesn't seem to work with containable. (I haven't tried it outside of a containable context).
return $this->find( "all", array( 'conditions' => array('Gallery.id' => $gallery_id), 'contain' => array( 'Photo' => array( 'order' => 'Photo.created DESC', 'limit' => $this->thumbsPerPage, 'page' => $page ) ) ) ); generates this SQL: SELECT `Photo`.`page`, `GalleriesPhoto`.`gallery_id`, `GalleriesPhoto`.`photo_id` FROM `photos` AS `Photo` JOIN `galleries_photos` AS `GalleriesPhoto` ON (`GalleriesPhoto`.`gallery_id` = 7 AND `GalleriesPhoto`.`photo_id` = `Photo`.`id`) WHERE 1 = 1 ORDER BY `Photo`.`created` DESC LIMIT 12 As you can see it is trying to put 'page' in as if I had said 'fields' => array('page') and completely ignoring the value of $page. There is no 'page' column in Photo so naturally the query is failing. If I pull out the page option, the query runs just fine, but I have obviously lost the ability to index into the rows. Is this a bug? Have I misunderstood something? Is there a ridiculous typo here that I'm not seeing? -Sean --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---