How to correctly pass a flow variable into DB Query Reader's "?" placeholder? (Error: No value specified for parameter 1)

[takbb]

Yes indeed, the DB Looping node was given as the solution in the above, but it isn’t always obvious how it should be used especially at first, so hopefully the above post will help, with examples, and give some context.

Another related thread….

db looping

Hello @Jeff, DB Looping is a way to go in your case. You just have to get the syntax right. If the table place holder isn’t changed, then it will be replaced with the query from the database input port. So if you connect DB Table Selector node it will take selected table. Yes. Here is screenshot for better understanding: [DbLooping] Hope this helps! Br, Ivan

Example workflow on the hub

DB Looping Example – knime