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.


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.


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

ProductCodeQuantityWeight
BAN_0023803.243
BAN_0101209.928
APL_0001251.287
FWL_2203227.889


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


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