Im trying to input a static select statement in a transform node and send it to dbexecute node.
As an example, in my static data i have defined a string (Select * from table1 where id=1) where the col name is query i later send that to a dbexecute node
and in the script i write sqlSelect('query'), i have also defined an input (query) in this node.
When i try to run the execute node i get the error:
WARN: statement takes at least 2 parameters not 1
ERROR: Node execution terminated while initializing expert output by error: statement takes at least 2 parameters not 1
------------------------------
Henrik B
E.ON Sverige
------------------------------