cancel
Showing results for 
Search instead for 
Did you mean: 

How to use GetData in SQL in DataSource

Occasional Contributor

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 1
Occasional Contributor

Re: How to use GetData in SQL in DataSource

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

New Here?
Join us and watch the welcome video:
Top Kudoed Authors