Sql Execute Example
This example executes a query that returns a datatable that is formatted.
| 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>
|
|
| Example Result |
Copy Code
|
|---|---|
image/bmp image/gif image/jpeg image/png image/sgv+xml |
|