Executes the given query/statement and returns the result.

Syntax

Smartsite SXML CopyCode image Copy Code
any sql.scalar(string sql)
any sql.scalar(string sql, any[ ] parameters)

Parameters

Name Data Type Description
sql String SQL statement.
parameters Any[ ] Parameters for the specified sql statement.

Return Value

Data Type Description
Any Result of the specified statement.

Expand image Example

SXML