executeScalarQuery

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 returns the first scalar value from the resultset.

Syntax

executeScalarQuery(query[, connectionName])

• Parameters

  • string query - The query to execute.

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

• Results

  • Value - The first value returned from the query.

Examples

For the following examples, suppose there was a table 'weights' that contained these values.

ProductCode	Quantity	Weight
BAN_002	380	3.243
BAN_010	120	9.928
APL_000	125	1.287
FWL_220	322	7.889

Code Snippet

executeScalarQuery("SELECT MAX(Quantity) FROM weights", "MySQLConnection")  //would return 380

Code Snippet

executeScalarQuery("SELECT * FROM weights", "MySQLConnection") //would return a string "BAN_002"