xsl-list
[Top] [All Lists]

Re: filtering XML file using starts-with

2003-12-18 08:10:10
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(_at_)nag(_dot_)co(_dot_)uk>
Reply-To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
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