issue with where clause in mysql db component when comparing context variable with file name

[Sudhee_Maximus]

Hi There I am not able to figure out the reason behind the error in the place of FILENAME comparison with a context variable, I need to compare a filename stored in a context variable against the query with some other join values.

Unfortunately getting below error

Error :-

java.sql.SQLSyntaxErrorException: Unknown column 'XYZDATA_*****_********_****Test.dat' in 'where clause'

I want to know why this error occurs and how to solve this issue or what changes needed in the query to resolve this.

Thanks....

[Anonymous · Accepted solution]

try to add single quotes to the value, eg:

"...where filename='"+context.filename+"'"