executeQuery

This function is used by Ignition's Expression language.

Description

note

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.

Syntax

executeQuery(query, resultName[, datasource])

• Parameters

  • 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.

Examples

Code Snippet

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.