Escaping colon symbol ":" in ColdFusion CFScript string?

Viewed 168

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.

0 Answers
Related