Executes the given resultset query/statement and returns a DataTable.

Syntax

Smartsite SXML	Copy Code
any sql.execute(string sql) any sql.execute(string sql, any[ ] parameters)

Parameters

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

Data Type	Description
Any	Result of the specified statement.

Smartsite SXML	Copy Code
{buffer.set(a, sql.execute("select Nr, Name from MimeTypes where Substring(Name, 1, 6)='image/' order by Name"))} <se:format inputdata="a"> <se:rowformat>{this.field(Name)}{char.crlf()}</se:rowformat> </se:format>

SXML