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