Example 17-41: XSQL page to drive discussion forum search results

<?xml version="1.0"?>
<!-- ForumSearchResults.xsql: Paging display of search 'hits' -->
<?xml-stylesheet type="text/xsl" href="ForumStyle.xsl"?>
<page connection="xmlbook" xmlns:xsql="urn:oracle-xsql">
  <xsql:action handler="Paging" rows-per-page="5"
           url-params="forum daysAgo searchIn searchFor">
      select ForumSearch.Hits({@forum}+0,
                              {@daysAgo}+0,
                              NVL('{@searchIn}','S') ,
                              '{@searchFor}') as hits
        from dual
  </xsql:action>
  <breadcrumbs>
    <forumname url="Search.xsql">Search</forumname>
    <topicname>Results</topicname>
  </breadcrumbs>
  <data>
    <xsql:ref-cursor-function skip-rows="{@paging-skip}" 
                               max-rows="{@paging-max}">
       ForumSearch.Find(forumid   => {@forum}+0 ,
                        daysAgo   => {@daysAgo}+0 ,
                        searchIn  => NVL('{@searchIn}','S') ,
                        searchFor => '{@searchFor}')
    </xsql:ref-cursor-function>
  </data>
</page>