I am writing a query in CFScript for Informix database that looks something like this:
myQuery = new Query();
myQuery.setSQL("select something from someDatabase:someTable");
In Informix someDatabase:someTable
syntax means accessing table from external database but
In ColdFusion :parameter
is what you write to later pass parameters. So CF throws an error
Parameter
'someTable'
not found in the list of parameters specified
How do I escape that :
symbol?
I tried `\` - it did not work.
Edit: I tried with backticks like so:
myQuery.setSQL("select something from `someDatabase:someTable`");
and now error message says
Parameter 'someTable`' not found in the list of parameters specified
Notice there is backtick after someTable, so it treats backtick as part of variable name.