Talend community forum / Query with row.X returns 0 rows. Works without row.X

ffwrude · 2012-06-29 16:48:00

Tags: [flowtoiterate, PostgreSQL, query]

Hi,

When i execute the following query :
"
SELECT * FROM adresses_"+row1.id+"
"
I got 0 results.
When i send via mail the tPostgresql_input.QUERY

I get : "SELECT * FROM adresses_1"

If i execute it. It gets me results.

Why ? It's starting to get me really mad...

"Job is :"

Code:

tpostgremysql_input => tflowTotierate => Tpostgresql_input => tpostgresql_output

Basicly the first tpostgresql gets numbers and the second do the SELECT * FROM number

Thanks by advance

pedro · 2012-07-02 04:15:16

Hi

Which version of TIS do you use?
Are all schema of these tables the same?
The query is correct.

Regards,
Pedro

ffwrude · 2012-07-02 09:42:07

Hi.

I know this is correct. Hence the question I use TIS 4.2.2 (or .3) All of the schemas are the same. I'm gonna wait until this afternoon but if no one can help i'll do it in PHP (can't wait forever ).

Thank your reply. If you have any ideas

(sorry for my bad english. Just woke up)/

pedro · 2012-07-02 10:00:14

Hi

Please show us the settings of tPostgresqlInput_2. A screenshot is preferred.

Regards,
Pedro

ffwrude · 2012-07-02 10:44:53

Thanks for your answer.

What do you mean when you say settings ? Basic ? Advandced ? Because if it's basic there's just the connexion info and the request. If i make you a screenshot i'm gonna have to "black out" a lot of the tables names and connexion info (because it's the name of the company or something related).

pedro · 2012-07-02 10:54:19

Hi

I try to reproduce this issue. But failed. I get 10 rows from the second tPostgresqlInput.

So I want to know whether you have filled Database and DB Schema on tPostgresqlInput.
I try to find out some different details between your job and my job.

Regards,
Pedro

ffwrude · 2012-07-02 11:22:37

I got it to work if i use a context variable instead of row.X

I have schema AND database filled.

That's odd. If i go back to row.X it doesn't work.

pedro · 2012-07-03 04:42:46

Hi

Still cannot reproduce it under TIS 4.2.2.

Regards,
Pedro

Announcement

Unanswered posts

#1 2012-06-29 16:48:00

Query with row.X returns 0 rows. Works without row.X

Code:

#2 2012-07-02 04:15:16

Re: Query with row.X returns 0 rows. Works without row.X

#3 2012-07-02 09:42:07

Re: Query with row.X returns 0 rows. Works without row.X

#4 2012-07-02 10:00:14

Re: Query with row.X returns 0 rows. Works without row.X

#5 2012-07-02 10:44:53

Re: Query with row.X returns 0 rows. Works without row.X

#6 2012-07-02 10:54:19

Re: Query with row.X returns 0 rows. Works without row.X

#7 2012-07-02 11:22:37

Re: Query with row.X returns 0 rows. Works without row.X

#8 2012-07-03 04:42:46

Re: Query with row.X returns 0 rows. Works without row.X

Board footer