Smartsite SXML CopyCode image Copy Code
<se:sqlquery sql="select top 10 Name from FileTypes order by Nr">
    <se:parameters>
        <se:parameter name="format">
    
            <!--// Print a caption row every 5 lines -->
            <se:captionformat expression="this.rownumber() % 5 == 1">
                <h1>File types</h1>
            </se:captionformat>
        
            <!--// Format each row with this rowformat -->
            <se:rowformat>
                {this.field(1)}<br />
            </se:rowformat>
      
        </se:parameter>
 
    </se:parameters>
</se:sqlquery>
Example Result CopyCode image Copy Code
<h1>File types</h1>
            
                Web Page (.html)<br />
            
                Cascading Style Sheet (.css)<br />
            
                Plain Text (.txt)<br />
            
                XML (.xml)<br />
            
                GIF Image (.gif)<br />
            
                <h1>File types</h1>
            
                JPEG Image (.jpg)<br />
            
                PNG Image (.png)<br />
            
                Word document (.doc)<br />
            
                Javascript (.js)<br />
            
                XHTML Web Page (.html)<br />