Re: [xsl] filtering XML file using starts-with

["Dan" <dan@xxxxxxxxxxxxxxx>]

Thax for the feedback.  This works, kind of.  I am not getting an error anymore, but I am also not getting any results. 

I am inculding a copy of a few elements from the XML file.  Using the xsl:for-each statement you gave me, shouldn't I get the following records back?  I ahve verified that $sModule = 1 but I get no records back?  Any idea what I am doing wrong?

<?xml version="1.0" ?> 
- <Sales>
- <Summary>
- <Employee>
  <value>Gazlay-Martin, Janet</value> 
  </Employee>
- <Module>
  <value>101</value> 
  </Module>
- <ResignTotalQuota>
  <value>8686333</value> 
  </ResignTotalQuota>
- <NewTotalQuota>
  <value>263844006.925</value> 
  </NewTotalQuota>
- <StrategicTotalQuota>
  <value>60794058.915</value> 
  </StrategicTotalQuota>
- <TotalTotalQuota>
  <value>272530339.925</value> 
  </TotalTotalQuota>
- <NewBucketQuota>
  <value>0</value> 
  </NewBucketQuota>
- <ResignTotalObjective>
  <value>0</value> 
  </ResignTotalObjective>
- <NewTotalObjective>
  <value>181000000</value> 
  </NewTotalObjective>
- <NewBucketObjective>
  <value>0</value> 
  </NewBucketObjective>
- <StrategicTotalObjective>
  <value>18100000</value> 
  </StrategicTotalObjective>
- <TotalTotalObjective>
  <value>181000000</value> 
  </TotalTotalObjective>
- <PercentResignTotal>
  <value>0</value> 
  </PercentResignTotal>
- <PercentNewTotal>
  <value>145.77</value> 
  </PercentNewTotal>
- <PercentStrategicTotal>
  <value>335.87</value> 
  </PercentStrategicTotal>
- <PercentTotalTotal>
  <value>150.56</value> 
  </PercentTotalTotal>
- <PercentNewBucket>
  <value>0</value> 
  </PercentNewBucket>
- <JobTitleCode>
  <value>BSEM</value> 
  </JobTitleCode>
- <MarketSegmentCode>
  <value>1</value> 
  </MarketSegmentCode>
- <RowCounter>
  <value>1575</value> 
  </RowCounter>
  </Summary>
- <Summary>
- <Employee>
  <value>Vacant, 101</value> 
  </Employee>
- <Module>
  <value>101</value> 
  </Module>
- <ResignTotalQuota>
  <value>8686333</value> 
  </ResignTotalQuota>
- <NewTotalQuota>
  <value>263869006.925</value> 
  </NewTotalQuota>
- <StrategicTotalQuota>
  <value>60794058.915</value> 
  </StrategicTotalQuota>
- <TotalTotalQuota>
  <value>272555339.925</value> 
  </TotalTotalQuota>
- <NewBucketQuota>
  <value>0</value> 
  </NewBucketQuota>
- <ResignTotalObjective>
  <value>0</value> 
  </ResignTotalObjective>
- <NewTotalObjective>
  <value>190000000</value> 
  </NewTotalObjective>
- <NewBucketObjective>
  <value>0</value> 
  </NewBucketObjective>
- <StrategicTotalObjective>
  <value>19000000</value> 
  </StrategicTotalObjective>
- <TotalTotalObjective>
  <value>190000000</value> 
  </TotalTotalObjective>
- <PercentResignTotal>
  <value>0</value> 
  </PercentResignTotal>
- <PercentNewTotal>
  <value>138.87</value> 
  </PercentNewTotal>
- <PercentStrategicTotal>
  <value>319.96</value> 
  </PercentStrategicTotal>
- <PercentTotalTotal>
  <value>143.45</value> 
  </PercentTotalTotal>
- <PercentNewBucket>
  <value>0</value> 
  </PercentNewBucket>
- <JobTitleCode>
  <value>SR-GMBO</value> 
  </JobTitleCode>
- <MarketSegmentCode>
  <value>1</value> 
  </MarketSegmentCode>
- <RowCounter>
  <value>1575</value> 
  </RowCounter>
  </Summary>
- <Summary>
- <Employee>
  <value>Savino, Jeffrey</value> 
  </Employee>
- <Module>
  <value>1011</value> 
  </Module>
- <ResignTotalQuota>
  <value>2800575</value> 
  </ResignTotalQuota>
- <NewTotalQuota>
  <value>67778540.8</value> 
  </NewTotalQuota>
- <StrategicTotalQuota>
  <value>8983476.12</value> 
  </StrategicTotalQuota>
- <TotalTotalQuota>
  <value>70579115.8</value> 
  </TotalTotalQuota>
- <NewBucketQuota>
  <value>0</value> 
  </NewBucketQuota>
- <ResignTotalObjective>
  <value>0</value> 
  </ResignTotalObjective>
- <NewTotalObjective>
  <value>73000000</value> 
  </NewTotalObjective>
- <NewBucketObjective>
  <value>0</value> 
  </NewBucketObjective>
- <StrategicTotalObjective>
  <value>7300000</value> 
  </StrategicTotalObjective>
- <TotalTotalObjective>
  <value>73000000</value> 
  </TotalTotalObjective>
- <PercentResignTotal>
  <value>0</value> 
  </PercentResignTotal>
- <PercentNewTotal>
  <value>92.84</value> 
  </PercentNewTotal>
- <PercentStrategicTotal>
  <value>123.06</value> 
  </PercentStrategicTotal>
- <PercentTotalTotal>
  <value>96.68</value> 
  </PercentTotalTotal>
- <PercentNewBucket>
  <value>0</value> 
  </PercentNewBucket>
- <JobTitleCode>
  <value>GMBO</value> 
  </JobTitleCode>
- <MarketSegmentCode>
  <value>1</value> 
  </MarketSegmentCode>
- <RowCounter>
  <value>1575</value> 
  </RowCounter>
  </Summary>


---------- Original Message ----------------------------------
From: David Carlisle <davidc@xxxxxxxxx>
Reply-To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Date:  Thu, 18 Dec 2003 14:49:52 GMT

>
>Without showing us the input form you are making us guess....
>
>	<xsl:starts-with(Module, $sModule)>
>
>there is no xsl:starts-with element, so that will be a synatx error.
>
>You want something like
>
><xsl:template match="/">
><xsl:for-each select=Sales/Summary[starts-with(Module,$sModule)]">
><xsl:sort select....
>
>
>assuming Module is a child of Summary
>
>
>-- 
>http://www.dcarlisle.demon.co.uk/matthew
>
>________________________________________________________________________
>This e-mail has been scanned for all viruses by Star Internet. The
>service is powered by MessageLabs. For more information on a proactive
>anti-virus service working around the clock, around the globe, visit:
>http://www.star.net.uk
>________________________________________________________________________
>
> XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
>
>

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list