executeQuery

This feature was removed from Ignition in version 8.0.0

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.