Example
Smartsite SXML |
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>
|