How to pass variable to tMysqlInput?

[Anonymous]

Hi Talend Community,

I have a job that needs to do the following:

extract data variable from table -> Iterate row-> select new data set based on variable input.

Here is my current job

Here is my tMysqlInput_2 select:

"select  result from details where customerid ="+((String)globalMap.get("row1.customer"))

When I execute I get the following error

Exception in component tMysqlInput_2
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'AF214DS' in 'where clause'

It seems to be replacing the variable with the column name....

[TRF · Accepted solution]

Change the expression to build the SQL query, because value must be enclosed between '' :

"select  result from details where customerid = '"+((String)globalMap.get("row1.customer"))+"'"