SqlQuery Scalar Example

By default the query yields a datatable that can subsequently be formatted or returned. In this example however, the user does not want to display a datatable but a single result. This is accomplished by setting the mode parameter to scalar.

Smartsite SXML CopyCode image Copy Code
<se:sqlquery
    mode="scalar"
    sql="select Title from vwActive where Nr=4810"
/>
Example Result CopyCode image Copy Code
This is a sample page