Smartsite SXML CopyCode image Copy Code
<se:sqlquery sql="select nr, title from vwContent where Nr in (24668, 27435, 27436) order by Nr" save="data" resulttype="datatable" />
{datatable.toxml($data)}
Example Result CopyCode image Copy Code
<NewDataSet>
  <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
    <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:MainDataTable="sqlquery" msdata:UseCurrentLocale="true">
      <xs:complexType>
        <xs:choice minOccurs="0" maxOccurs="unbounded">
          <xs:element name="sqlquery">
            <xs:complexType>
              <xs:sequence>
                <xs:element name="nr" type="xs:int" minOccurs="0" />
                <xs:element name="title" type="xs:string" minOccurs="0" />
              </xs:sequence>
            </xs:complexType>
          </xs:element>
        </xs:choice>
      </xs:complexType>
    </xs:element>
  </xs:schema>
  <sqlquery>
    <nr>24668</nr>
    <title>Screwdriver XL Plus</title>
  </sqlquery>
  <sqlquery>
    <nr>27435</nr>
    <title>Screwdriver 300GT</title>
  </sqlquery>
  <sqlquery>
    <nr>27436</nr>
    <title>Screwdriver Deluxe 170</title>
  </sqlquery>
</NewDataSet>
SXML