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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.