No change at all. Get the same result.
[0] => Array
(
[0] => Array
(
[full_name] => Christher Lenander
)
)
On Mar 21, 10:00 pm, John Andersen <[email protected]> wrote:
> I haven't used this before, but reading the manual and checking your
> code, I come up with this change:
>
> 'fields' => array( 'CONCAT( User.firstname, \' \',
> User.lastname ) AS full_name' )
>
> There was a mismatching of the brackets, one was actually inside the
> CONCAT string.
> Hope this helps :)
> Enjoy,
> John
>
> On Mar 21, 9:51 pm, Chrillemeter <[email protected]> wrote:
>
> > 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'
> > )
> > )
> > );
>
> [snip]
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
