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

<se:format
    inputdata="{datatable.columns.getnames(buffer1)}"
    rowformat="Field '{this.field(key)}' of type '{this.field(value)}'"
    rowdelimiter=","
/>
Example Result CopyCode image Copy Code
Field 'nr' of type 'Integer',Field 'title' of type 'String'
SXML