Forum Discussion

Svetlana's avatar
Svetlana
Occasional Contributor
9 years ago

How to use GetData in SQL in DataSource

Hello,

 

I'm trying to use GetData in SQL Query.

 

  1. If I use an expression ... WHERE Column1 = “${TestStep1#Variable1 it errors out: Parsing error. Failed to parse SQL query. Invalid SELECT statement. Unexpected token ‘{’ at line.

  2. If I use an expression ... WHERE Column1 = “${PreparedProperty1#Variable1}” it errors out: Can’t get the connection for specified properties; com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name ‘${PreparedProperty1#Variable1}’.

How to use GetData in SQL in DataSource?

1 Reply

Sort By
  • Svetlana's avatar
    Svetlana
    Occasional Contributor
    9 years ago

    Sorry, forum deleted the second half of my message.

     

    it errors out: Can’t get the connection for specified properties; com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name ‘${PreparedProperty1#Variable1