I am converting a rather large project to railo, and have lots of queries where literals are double quoted that are throwing errors. For example select * from sometable where somecolumn="Y" yields Invalid column name 'Y'. However, select * from sometable where somecolumn='Y' works fine.
Is there a connection parameter that allows the dbl quoted syntax? I have too many templates and queries to manually edit. Any and all help greatly appreciated.
Did you ever find an answer to this? I haven't gotten any answers to my question about turning quoted_identifier off. I would think that same option would be relevant to you.