ConnectionHelper.ExecuteScalar Method (String, QueryDataParameters, QueryMacros)

Executes the query and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 11.0.0

Syntax

public static Object ExecuteScalar(
	string queryName,
	QueryDataParameters parameters = null,
	QueryMacros macros = null
)

Parameters

queryName

Type: System.String
Name of the query in format application.class.queryname

parameters (Optional)

Type: CMS.DataEngine.QueryDataParameters
Query parameters.

macros (Optional)

Type: CMS.DataEngine.QueryMacros
Query expressions.

Return Value

Type: Object