how to pass a variable in a tMSSQLInput based on a query ?

[Anonymous]

hello
I would like to use one SQL query that could vary based upon one variable, how can I pass this parameter in the SQL query ?
David

[Anonymous]

Perl or Java project?

[Anonymous]

Java :
"SELECT * from TABLE
where S.CODE_PER IN ('2007070','2007080','2007090') "
I need to pass ('2007070','2007080','2007090') as a variable : current month, month -1 and month -2 as YYYYMM0

[_AnonymousUser]

Hi dcopp.
Try this (I've discover it today):
"SELECT * from TABLE
where S.CODE_PER IN ('"+context.getProperty("date")+"',ecc) "
Bye

[Anonymous]

hello
How did you define your context ?
I don't get any rows with such script, more the 'ecc' column is unknown to me
Anybody succeeded in passing a variable value into a SQL script ?

[Anonymous]

Under tab "Repository" there is an icon called "Contexts". Right click->create context
Bye

[c0utta]

dcopp,
All my queries use context variables with MSSQL - have a look at my post 1164. The screen print will show you how to use context variables with in a query. As long as the query resolves to a string, that's all that matters.
Can I also be so bold as to suggest to read the User Guide? Contexts are clearly documented in there, as are creation of context variables.
Cheers,
c0utta

[Anonymous]

Ok, I have tried to find the answer in many places in this forum but I haven't been successful.
I have two table: one with the unique keys and a second with the associated values.
So I use a first tMysqlInput to get the keys (select id from id_table) --> Iterate --> tMysqlInput (select data from data_table where data_id = tMysqlInput.id)
My issue is that I don't know how to iterate on the id result from the first query and use the query result as a parameter in the second component.

[Anonymous]

Hello raton

So I use a first tMysqlInput to get the keys (select id from id_table) --> Iterate --> tMysqlInput (select data from data_table where data_id = tMysqlInput.id)

For example:
tMysqlInput--row1-->tLogRow
|
iterate
|
tMySQLInput("select data from data_table where data_id ="+String.valueOf(row1.id))
Best regards

shong

[Anonymous]

I can feel that I am getting a lot closer to the solution.
The equivalent of that line "tMySQLInput("select data from data_table where data_id ="+String.valueOf(row1.id)) " for Perl would be ... ??
(sorry for the extra question, I just saw this topic was tagged "java" ... )