Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! X
I'm trying to use a string input in my query to return the columns based on the tableName input provided but i'am seeing this error result and here is my script:
When the query service is called with the input the query executed looks like:
and so i think this syntax should be correct. Any advice on this?
Thanks
Message was edited by: Sushant Pandey branched from https://community.thingworx.com/message/59921#59921 as new question
Solved! Go to Solution.
Hi Andrew,
For String substitution you'd want to use << >> instead of [[ ]]. I believe this is discussed more at length here under the topic JDBC Extensibility (at the end of that documentation)
Hope this'd help.
Hi Andrew,
For String substitution you'd want to use << >> instead of [[ ]]. I believe this is discussed more at length here under the topic JDBC Extensibility (at the end of that documentation)
Hope this'd help.