concat in query calc element

[leblancphil]

I have tried many ways to do this
.....
$myQuery
->select (concat ('nom,' ',prenom')).....

no pb with the query itself but I cant find the correct concat way

Some idea ?
Thanks

 

[georgie]

Hello

By one of this ways maybe:

$myQuery
->select (concat (firstname, ' ', lastname)).....

my_table___field1,' text value ', my_table___field2, 'punctuation'

or sometime this:

return '{my_table___price_field} Euros' ;

 

[leblancphil]

Thanks
I only understand the first one that doen't work

 

[georgie]

Hello, is it OK?

I feel you are french, no? I have this page on my website: http://hg-map.fr/astuces/38-astuces-php-sur-le-cck-fabrik?showall=&start=2

 

[cheesegrits]

You have to quote it, like ...

$myQuery->select("CONCAT(firstname, ' ', lastname) AS fullname");

Depending on exactly what you are doing, you don't have to use the "AS some_field_name", but it doesn't hurt to use it.

-- hugh

 

[leblancphil]

i finally get it work, thanks to all.
Georgie, I had already bookmarked your website, that is realy helpfull