inputs:
sql – input SQL query directly in the operator. To specify parameters use symbol “?” (e.g. select * from notes where date_modified >= ?). Only one query can be executed within the SQL Query operator.
- Required: yes
param x – input value for each parameter defined in SQL query (what should be set instead of “?”). Symbols “?” are filled with provided values in the order they are inputted.
- Required: no (depends on whether there are any parameters)
outputs:
result – the result of SQL Query execution:
- In case of an error in SQL Query result contains the error message
- For SELECT statement the result is an array of returned data, where each row is represented as an array as well. Can be processed with For Each Element
- For UPDATE, DELETE, INSERT statements the result is 1 (true) when executed successfully or 0/empty (false) otherwise.
Click to rate this post!
[Total: 0 Average: 0]