We recently moved over some of our templates to use the Query module to reduce the number of DB queries happening.
However I'm now experiencing an issue where some of the field data is being returned un-escaped and when I try and output the result using PHP's json_encode() function I'm getting a PHP error.
: syntax error, unexpected 'flying' (T_STRING), expecting ')' in
Here's my question:
- Should the Query Module escape strings?
- If not why not and how should I overcome this?
- I'm not able to use MySQL REPLACE(column, '"', ''') as this causes the QUERY module to throw and SQL error. Any other way I can escape the quotes?