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

Executes a select query using the given ConnectionName (or the default connection it omitted) and stores the result into a global ResultSetName.

executeQuery(query, resultName[, datasource])

  • Parameter

string query - The query to execute.

string resultName - The name of the global result set.

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

  • Results

int - The number of rows in the returned table.

executeQuery("SELECT * FROM table", "MyResult", "MySQLConnection") //would store the results in "MyResult" and return an integer based on how many rows were in the table.