DB Query Reader

[Gimli]

Hi Yas,

Looking for some help with DB Query’s. Im looking to run a script
that updates a SQL database. I would like to input some variables
to the DB Query Reader for use in the query script. These variables will
change…
Cant seem to find a way to do that.

anyways any suggestions would be great

thanks!

[mlauber71]

@Gimli you could take a look at this example where a Flow Variable is being used in a DB Query reader.

Variables type Long VS DB SQL Nodes

@Fra_S3k_knime would it be possible to tell us what you actually want to do? Load data into a database? Use Flow Variables in a SQL query? Mabye you could produce a small workflow to show where things go wrong. [EDIT: created an example to experiment with settings] [image]

[Gimli]

Ah flow variables is what I needed! thanks again!

[JWebb]

I’ve also found using another query to calculate dates and turning that into a variable helps a lot if one of your variables is a dynamic date. Then feed those into your main query.