Hello!

I got a problem with $this->Model->find() and sql-functions such as
CONCAT.

CODE
---------------------------------
$this->User->find(
        'all',
        array(
                'fields' => array(
                                'CONCAT(User.firstname,\' \'User.lastname)) AS 
full_name'
                        )
        )
);


When I use sql function with find() it returns arrays lookin like
this.

RESULT
---------------------------------
Array
(
    [0] => Array
        (
            [0] => Array
                (
                    [full_name] => Christher Lenander
                )

        )
)
--------


I want the returned array to look like this
--------
Array
(
    [0] => Array
        (
            [User] => Array
                (
                    [full_name] => Christher Lenander
                )

        )
)

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

Reply via email to