execute & Store Mysql Query


Only use this task if you could work with MySQL Querys!

task_mysqlquery.pngThis task executes a query against the database and save the first row of the result into an environmental variable, which could be used by other tasks.

An equal result you could get with the function wf_dbquery inside custom expressions, which does exactly the same.

Example

You execute a query which get a row with the columns “colA”, “colB”, “colC”, “colD” and you save this to the environmental variable mysqlresult.
You could use these values by $env[“mysqlresult”][“colA”] or $env[“mysqlresult”][“colB”] …

©2021 Redoo Networks GmbH
Powered with ♥ by XWiki