Smartsite SXML CopyCode image Copy Code
<se:sqlquery sql="select nr, title from vwActive where nr=2" save="buffer1" resulttype="datatable" />

Field {datatable.columns.getname(buffer1, 1)} is of type {datatable.columns.gettype(buffer1, 1)}.
Field {datatable.columns.getname(buffer1, 2)} is of type {datatable.columns.gettype(buffer1, 2)}.
Example Result CopyCode image Copy Code
Field nr is of type Integer.
Field title is of type String.
SXML