Skip to main content
A
aseaton12-Amethyst
12-Amethyst
June 12, 2017
Solved

Trying to use string input in my query to return the columns based on the tableName input provided but i'm seeing error

  • June 12, 2017
  • 1 reply
  • 1792 views

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:

query script.PNG

error message for database columns script with input.PNG

When the query service is called with the input the query executed looks like:

query for columns script.PNG

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

Best answer by supandey

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.

1 reply

S
supandey5-Regular MemberAnswer
5-Regular Member
June 12, 2017

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.

Terms & ConditionsAccessibility statement