Good morning,

When I insert this query into an RsForm text field, I get an error at the REPLACE level. In phpMyAdmin no problem.
Can you tell me if already REPLACE is allowed in RsForm?
If so, where could the error come from?
thanks in advance
Sincerely,
Michael

//<code>
$items = array();
$db = JFactory::getDbo();
$db->setQuery("SELECT f857n_content.id, REPLACE(title, 'A paraître' , ' '), f857n_content.created_by_alias
FROM f857n_content
INNER JOIN f857n_fields_values ON f857n_content.id = f857n_fields_values.item_id
WHERE f857n_content.catid = 13
AND f857n_content.created_by_alias >= '95'
AND f857n_fields_values.value = 'oui'
AND f857n_content.state = 1
ORDER BY f857n_content.created_by_alias DESC");
$results = $db->loadObjectList();

foreach ($results as $result) {
$value = $result->created_by_alias;
$label = $result->title;
$items[] = '8|'.$label.'<br />';
}
$items = implode("\n", $items);
return $items;
//</code>