Nom de colonne non valide

[hbensaid]

Hi,

Can you please help to fix this issue:

 i'm try to query Ratechange value from my MSSQL DB basing on the Rate selected from tfixFlow input(liste of value) but i'm getting this error after run job:

[statistics] connected
Exception in component tMSSqlInput_1 (SubJob_tRunjob)
java.sql.SQLException: Nom de colonne non valide : 'EUR'.

...

Thx in advance

[TRF · Accepted solution]

Change the where clause like this:

... where RateChange.Rate = '" + (String)globalMap.get("row1.input") + "'"

beware of single quote before the 1rst double one and at the end of the where clause as you want the code generated looking like this:

... where RateChange.Rate = 'EUR'

Right?

[hbensaid]

Hi TRF,

It's work now thank you for your help & support.

[TRF]

Great!
Don't forget to mark your case as solved (Kudo also accepted)