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> |
Example Result | 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 |