<?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> |