SELECT statement with WHERE

stephbzr — Fri, 15 Nov 2024 22:30:49 GMT

Hello,

I am trying to execute a SELECT query with WHERE from a file name. But I get the following error:

I can't find what the problem is. Can you help me or tell me if there is another way?

Also, I am trying to do 2 processing flow. If the query returns at least one line then flow1. But if the query does not return any rows then flow2. Can you give me an idea?

Re: SELECT statement with WHERE

Anonymous — Sun, 02 Oct 2022 13:40:04 GMT

In this case try to check the Generated Java code, by clicking on the Code tab.

The solution will be to chnage that last line:

nom_fic = '+ to:

nom_fic ='" +

and at the end of the line:

+ "'"

topic SELECT statement with WHERE in Talend Studio

SELECT statement with WHERE

Re: SELECT statement with WHERE