Forum Discussion

Computer_Resear's avatar
Computer_Resear
Occasional Contributor
17 years ago

Re: Datasource query property expansion errors.

I have created a datasource step to execute the following sql: select * from aTable where column1 = '777' and column2 = ${="'" + ${Properties#theProperty} + "'"} I created a properties step ...
M_McDonald's avatar
M_McDonald
Super Contributor
17 years ago
The equivalent of this works for me (SQL Server):

[tt:2rqwu4od]select *
from aTable
where column1 = '777'
and column2 = '${Properties#theProperty}'[/tt:2rqwu4od]