Smartsite SXML CopyCode image Copy Code
{buffer.set(a, datatable.createempty())}

{datatable.columns.add($a, 'Name', string)}
{datatable.columns.add($a, 'Type', string)}
{datatable.columns.add($a, 'Value', string)}

{datatable.rows.add($a, 'nr', 'integer', 27436)}
{datatable.rows.add($a, 'title', 'string', 'Screwdriver 300GT')}

<se:sqlquery sql="select title from contents where nr=?:nr or title=?:title order by title">
    <se:parameters>
        <se:parameter name="params">
            <se:collection inputdata="a"/>
        </se:parameter>
        <se:parameter name="format">
            <se:rowformat>{this.field(title)}</se:rowformat>
            <se:rowdelimiter>,</se:rowdelimiter>
        </se:parameter>
    </se:parameters>
</se:sqlquery>
Example Result CopyCode image Copy Code
Screwdriver 300GT,Screwdriver Deluxe 170