Smartsite SXML CopyCode image Copy Code
{buffer.set(params, datatable.createforinputdata(sqlquery, params))}
{datatable.rows.add($params, nr, integer, 4810)}

Datatable definition: {buffer.get(params)}
Datatable values: {debug.write($params)}

<se:sqlquery rowformat="Title = {this.field(title)}">
    <se:parameters>
        <se:parameter name="sql">
            select title from vwContent where nr=?:nr
        </se:parameter>
        <se:parameter name="params">
            <se:collection inputdata="params" />
        </se:parameter>
    </se:parameters>
</se:sqlquery>
Example Result CopyCode image Copy Code
Datatable definition: SXMLDataTable (Name=params; Rows=1; Columns=name,type,value)
Datatable values: name=nr; type=integer; value=4810

Title = This is a sample page
SXML