02-02-2022 11:25 PM
Dear Ladies and Gentlemen,
we are trying build a script for the UCCX using the Cisco Unified CCX Editor.
But when it comes to the SQL query (we need to connect to our database and get some information out of it) we have a problem, because in our database we have the tables named like "$ServiceHeader" and the "$" is the problem here ... because the Editor thinks we want to declare a variable but its just part of the name of the table ... we tried masquerading the $ in different ways but with no success.
Do you have any ideas how to avoid the editor thinking its a variable and telling the editor its just a part of the tables name?
Thank you very much in advance.
02-03-2022 02:16 AM
Not very sure on this, but as the system is pretty much Java based it could work by following what is outlined in this link.
02-03-2022 05:31 AM
I guess my first question would be why you put special characters in a table name? Failing that, you could always create a single table view in the DB that doesn't have special characters in the name to avoid the problem.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide