I am trying to make a form web part with 2 text boxes. I want the first text box to be able to search by first name, and the second box to search by last name. You will be able to use either or both boxes, and do wildcard searches.
The sample code below works for the "First_Name" text box, but I can't seem to figure out how to make it work with the "Last_Name" text box. How do I make this happen? The full code is attached. Thanks.
I am using Sharepoint 2007 MOSS.
<xsl:variable name="smallcase" select="'abcdefghijklmnopqrstuvwxyz'" />
<xsl:variable name="uppercase" select="'ABCDEFGHIJKLMNOPQRSTUVWXYZ'" />
<xsl:variable name="searchcaps" select="translate($SearchTerm, $smallcase, $uppercase)" />
<xsl:variable name="Rows" select="/dsQueryResponse/Rows/Row[contains(translate(@First_Name, $smallcase, $uppercase), $searchcaps)]"/>