Example 17-39: XSQL page to drive the forum search criteria form

<?xml version="1.0"?>
<!-- Search.xsql: Forum search criteria form -->
<?xml-stylesheet type="text/xsl" href="ForumStyle.xsl"?>
<page connection="xmlbook" xmlns:xsql="urn:oracle-xsql">
  <breadcrumbs>
    <forumname>Search</forumname>
  </breadcrumbs>
  <dataform target="ForumSearchResults.xsql" submit="Search">
    <xsql:set-page-param name="default" value="{@id}"/>
    <item type="text" name="searchFor" size="30" label="Search For"/>
    <item type="list" name="searchIn" label="In">
      <ROWSET>
        <ROW><VALUE>E</VALUE><DISPLAY>Entire Message</DISPLAY></ROW>
        <ROW><VALUE>S</VALUE><DISPLAY>Subject Only</DISPLAY></ROW>
      </ROWSET>
    </item>
    <item type="list" name="forum" label="In Forum">
      <xsql:include-param name="default"/>
      <xsql:query>
         select id as value, name as display
           from forum
         union all
         select -1, 'All Forums'
           from dual
         order by 1
      </xsql:query>
    </item>
    <item type="list" name="daysAgo" label="By Date">
      <ROWSET>
        <ROW><VALUE>0</VALUE><DISPLAY>Any Date</DISPLAY></ROW>
        <ROW><VALUE>-1</VALUE><DISPLAY>Since Yesterday</DISPLAY></ROW>
        <ROW><VALUE>-7</VALUE><DISPLAY>In Past Week</DISPLAY></ROW>
        <ROW><VALUE>-14</VALUE><DISPLAY>In Past Two Weeks</DISPLAY></ROW>
        <ROW><VALUE>-21</VALUE><DISPLAY>In Past Three Weeks</DISPLAY></ROW>
      </ROWSET>
    </item>
  </dataform>
</page>