Six Stars

Nom de colonne non valide

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

1 ACCEPTED SOLUTION

Accepted Solutions
Forteen Stars TRF
Forteen Stars

Re: Nom de colonne non valide

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?

 


TRF
3 REPLIES
Forteen Stars TRF
Forteen Stars

Re: Nom de colonne non valide

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?

 


TRF
Six Stars

Re: Nom de colonne non valide

Hi TRF,

 

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

 

 

Forteen Stars TRF
Forteen Stars

Re: Nom de colonne non valide

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

TRF