Server side concat_ws

greggreggreg

I am trying to search firstname{space}lastname server side. I assume its simple, what am I doing wrong please.

$columns = array(
    array( 'db' => 'users_id', 'dt' => 'users_id' ) ,
    array( 'db' =>  'CONCAT_WS(" ", users_firstname, users_lastname)', 'dt' => 'users_fullname' ),
    array( 'db' => 'users_firstname', 'dt' => 'users_firstname' ),
    array( 'db' => 'users_lastname', 'dt' => 'users_lastname' )
);

allan

It isn’t simple actually - the demo PHP SSP class doesn’t support SQL functions, so you’d either need to modify the script to add that, or use a client-side renderer for it (which is what I’d do, and do in e.g. the Editor examples.

Allan