This function is only available in Transaction Group Expression Items and Expression Tags.

Executes an update query using the given ConnectionName (or the default connection it omitted) and returns the number of rows effected.

executeUpdateQuery(query[, connectionName])

  • Parameters

string query - The query to execute.

string connectionName - Optional. The name of the database connection.

  • Results

int - The number of rows affected.

executeUpdateQuery(query, [ConnectionName])

executeUpdateQuery("UPDATE table SET columnName1 = 15.89 WHERE index = 4", "MySQLConnection") //would return a 1 and update the table.