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