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 ...
Computer_Resear's avatar
Computer_Resear
Occasional Contributor
17 years ago
Some additional information:

If the property value is a numeric (say 123), it works but if the property value contains an alphabet (say 1B or B or BBBB etc.), the exception is thrown.

Thanks,

Srini