Filtering list: Condition IN with 'SELECT REPLACE' query

[fleblic]

I am trying to filter a list with an IN condition. The query is (see attached image file).

SELECT REPLACE (cb_unidaddocentepediatria, '|*|',',') FROM eeq1g_comprofiler WHERE user_id = {$my->id}

Something must be wrong in this part but what?
REPLACE (cb_unidaddocentepediatria, '|*|',',')

Many thanks

 

[fleblic]

It works with
SELECT cb_unidaddocente FROM eeq1g_comprofiler WHERE user_id = {$my->id}
but It doesn't work with
SELECT REPLACE ( cb_unidaddocente , '|*|',',') FROM eeq1g_comprofiler WHERE user_id = {$my->id}

 

[cheesegrits]

Use fabrikdebug, see if the query is being malformed somehow.

-- hugh