| Backslash adding in CONCAT in calculated field [message #1482] |
Tue, 15 July 2008 16:56  |
bonzo_bcn
Messages: 152
Registered: June 2008
|
Senior Member |
|
|
I defined this calculated field in a relationship:
CONCAT_WS(',',participante.catsalut, participante.nombre, participante.apellido1,participante.apellido2) AS part_det
when I saved it it was automatically transformed to:
CONCAT_WS(\',\',participante.catsalut, participante.nombre, participante.apellido1,participante.apellido2) AS part_det
So when running the application I got this error:
Fatal Error: MySQL error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\',\',participante.catsalut, participante.nombre, participante.apellido1,partici' at line 1 (# 1064).
SQL query: SELECT SQL_CALC_FOUND_ROWS equipo.equipo_id, participante.participante_id, CONCAT_WS(\',\',participante.catsalut, participante.nombre, participante.apellido1,participante.apellido2) AS part_det, |
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
