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