<!--//
    Create datatable and cache it, saving the key for later use...
    Set resulttype to "none" to suppress output.
-->
<se:cache save="key = this.getcachekey()" resulttype="none" maxage="00:05">
    <se:sqlquery resulttype="datatable">
        <se:parameters>
            <se:parameter name="sql"> 
                select top 5 c.nr, c.title, u.fullname from  
                {channel.view()} c join vwUsers u 
                on c.userid=u.nr
                where c.nr in (SELECT nr FROM dbo.fn_RecurseChildren(2,0))
                order by c.nr
            </se:parameter>    
        </se:parameters>
    </se:sqlquery>
</se:cache>
<!--//
    Now, use the cached datatable as inputdata for Xlinks..
-->
<se:xlinks inputdata="key" trim="both">
    <se:parameters>
        <se:parameter name="rowformat">
            <li>{this.field(title)} - {this.field(fullname)}</li>{char.crlf()}
        </se:parameter>
        <se:parameter name="resultformat">
            <ul>{char.crlf()}{this.result()}</ul>
        </se:parameter>
    </se:parameters>
</se:xlinks>

<!-- //
    show a search form
-->
<form class="CoolForm" action="{request.location()}" method="get">
    <label for="q">Find</label> 
    <input class="Required Border Control TextBox" id="q" name="q" value="{request.query(q)}"/> 
    <br/>
    <input class="Control" type="submit" value="Search"/> 
</form>

{buffer.set(q, string.trim(request.query(q)), rem="Store our search buffer")}

<se:if expression="$q!=''">
    <se:paging id="srs" 
        pagesize="5"
        rem="Create a state machine for our paged search results"
    />

    
    <se:sqlquery 
        pagingid="srs"
        rem="SqlQuery macro bound to paging macro 'srs'"
        save="data"
        resulttype="datatable" 
        sql="select c.nr, c.title,c.description, c.moddate, u.fullname
            from {channel.view()} c 
            join vwUsers u on c.userid=u.nr
            where title like ? order by moddate desc"
        params="{string.concat('%', string.replace($q, '*','%'), '%')}"
    />

    <se:format inputdata="data" rem="Format the subset of the results">
        <se:rowformat>
            <li>
                <a href="{this.location()}">{this.name()}</a><br />
                <small>
                    {sys.iif(this.field(description)!='', string.concat(this.field(description), html.break()), '')}
                    {datetime.format(this.field(moddate), 'd MMM yyyy, HH:mm')} by {this.field(fullname, default='unknown author')}
                </small>
            </li>
        </se:rowformat>
        <se:resultformat>
            <h3>Results for '{buffer.get(q)}'</h3>
         
            <ul>
                {this.result()}
            </ul>
        </se:resultformat>
    </se:format>

    <!--//
        Show the paging navigation
    -->
    <span class="navbar {sys.iif(page.srs.count() == 1, 'hidden')}">
        {page.srs.goto(First)} 
        {page.srs.goto(Previous)}
        {page.srs.goto(Next)}
        {page.srs.goto(Last)}
        page {page.srs.current()} of {page.srs.count()}: 
        {page.srs.offset()} to {math.min(page.srs.totalcount(), page.srs.offset()+page.srs.size()-1)} of {page.srs.totalcount()} items.
    </span>

</se:if>