Double Quoted Literals in queries

Help
HenryG
2014-01-18
2014-04-08
  • HenryG
    HenryG
    2014-01-18

    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.

     
  • JJ Blodgett
    JJ Blodgett
    2014-04-08

    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.