it's not possible like this, use recursive option in settings array, but you
will still get something like this:

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
               )



--
Lep pozdrav, Tilen Majerle
http://majerle.eu



2011/3/20 Zeu5 <[email protected]>

> 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
> [email protected] For more options, visit this group
> at http://groups.google.com/group/cake-php
>

-- 
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
[email protected] For more options, visit this group at 
http://groups.google.com/group/cake-php

Reply via email to