Hi all, my pagination code in controller looks like this
$this->paginate = array( 'conditions' => array('OR' => array ( array('ProductImage.cover'=>true), array('ProductImage.cover'=>null), ), ), 'link'=>array('ProductImage'), 'fields'=>array('Product.*', 'ProductImage.id', 'ProductImage.filename', 'ProductImage.dir'), 'order'=> array('Product.created DESC') ); $this->paginate['conditions']['AND'] = array('Product.shop_id' => Shop::get('Shop.id')); I do not wish to change the conditions whatsoever. I have the following as the result of the pagination. Array ( [0] => Array ( [Product] => Array ( [id] => 8 [shop_id] => 2 [title] => test [code] => [description] => <p>test</p> [price] => 1.0000 [created] => 2011-03-03 09:51:41 [modified] => 2011-03-03 09:51:41 [status] => 1 [weight] => 1.0000 [currency] => SGD [weight_unit] => kg [shipping_required] => 1 ) [ProductImage] => Array ( [id] => 5 [filename] => wal_mart_t_shirt_for_web-1.jpg [dir] => uploads/products [product_id] => 8 [cover] => 1 [created] => 2011-03-03 09:51:41 [modified] => 2011-03-03 09:51:41 [mimetype] => image/jpeg [filesize] => 14479 ) ) [1] => Array ( [Product] => Array ( [id] => 7 [shop_id] => 2 [title] => test [code] => [description] => <p>test</p> [price] => 0.0000 [created] => 2011-03-03 08:42:16 [modified] => 2011-03-03 08:42:17 [status] => 1 [weight] => 0.0000 [currency] => SGD [weight_unit] => kg [shipping_required] => 1 ) [ProductImage] => Array ( [id] => 4 [filename] => wal_mart_t_shirt_for_web-0.jpg [dir] => uploads/products [product_id] => 7 [cover] => 1 [created] => 2011-03-03 08:42:17 [modified] => 2011-03-03 08:42:17 [mimetype] => image/jpeg [filesize] => 14479 ) ) I want this instead where the image value is taken from ProductImage.filename Array ( [0] => Array ( [id] => 8 [shop_id] => 2 [title] => test [description] => <p>test</p> [price] => 1.0000 [created] => 2011-03-03 09:51:41 [modified] => 2011-03-03 09:51:41 [status] => 1 [weight] => 1.0000 [currency] => SGD [weight_unit] => kg [shipping_required] => 1 [image] => wal_mart_t_shirt_for_web-1.jpg ) -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php