[xsl] RE: Including some records and excluding others in a search

["Lewis, Russell" <Russell.Lewis@xxxxxxxxxxxxxxxx>]

Sorry for the long, confusing post but here is the same question in a more
simplified version.(Funny the clarity you get from a good night's sleep)

I'm trying to learn how/do two things here:
1) If the user searches for "Data" ($searchtext = "Data") the output should
also include the fourth
  record because Field1 contains "all".
 2) But the output of this same search should also exclude any records where
Field1 contains "info"
  ($searchtext = "info"). You can see by the textsearch template that I have 3
case conversion
  variables that can be used to to include/exclude "All", "all", "ALL",
"Info", "info", or "INFO"

A statement like this includes "all" but I can't figure out how to get it to
also exclude "info"
 <xsl:for-each select="record[*[name() = $searchfield][contains(.,
$ProperText) or contains(., $UCASETEXT) or contains(., $lcasetext) or
../Field1[contains(., 'ALL') or contains(., 'all') or contains(., 'All')]]]">

XML Data

<?xml version="1.0"?>
<data>
  <record>
    <Field1>Data1-1</Field1>
    <Field2>Data1-2</Field2>
    <dtmField>2008-01-28T01:01:00Z</dtmField>
  </record>
  <record>
    <Field1>Info</Field1>
    <Field2>Data2-2</Field2>
    <dtmField>2008-01-28T02:02:00Z</dtmField>
  </record>
  <record>
    <Field1>Data3-1</Field1>
    <Field2>Data3-2</Field2>
    <dtmField>2008-01-28T03:03:00Z</dtmField>
  </record>
  <record>
    <Field1>all</Field1>
    <Field2>Data4-2</Field2>
    <dtmField>2008-01-28T04:04:00Z</dtmField>
  </record>
  <record>
    <Field1>All</Field1>
    <Field2>Data5-2</Field2>
    <dtmField>2008-01-28T05:05:00Z</dtmField>
  </record>
  <record>
    <Field1>info</Field1>
    <Field2>Data6-2</Field2>
    <dtmField>2008-01-28T06:06:00Z</dtmField>
  </record>
</data>

XSL Stylesheet
<!-- Include this just to show version and output method -->
<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform
<http://www.w3.org/1999/XSL/Transform> " version="1.0">
  <xsl:output method="html"/>

<!--
The "selected" value of thes parameters are filled in for this example.
Normally
they are passed from an external ASP VBScript that processes inputs from
another
form where the values are input by the user.
-->
  <xsl:param name="searchfield" select="Field1"/> <!-- Field to search -->
  <xsl:param name="searchtext" select="Data"/> <!-- Text to search for -->
  <xsl:param name="sortbyfield" select="Field2"/> <!-- Field to sort output by
-->
  <xsl:param name="sortorder" select="Descending"/> <!-- Sort order ascending
or descending -->

  <xsl:template name="textsearch">
    <xsl:for-each select="record[*[name() = $searchfield][contains(.,
$ProperText) or contains(., $UCASETEXT) or contains(., $lcasetext)]]">
      <xsl:sort select="*[name()=$sortbyfield]" order="{$sortorder}"/>
      <xsl:call-template name="resulttable"/>
    </xsl:for-each>
  </xsl:template>



Thanks Again,

Russ Lewis