Subject: Re: filtering XML file using starts-with
From: "Dan" <dan@xxxxxxxxxxxxxxx>
Date: Thu, 18 Dec 2003 09:10:10 -0600
|
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
| Current Thread |
- filtering XML file using starts-with
- Dan - Thu, 18 Dec 2003 09:14:49 -0500 (EST)
- <Possible follow-ups>
- Dan - Thu, 18 Dec 2003 10:18:42 -0500 (EST) <=
- Dan - Thu, 18 Dec 2003 11:20:54 -0500 (EST)
- Dan - Thu, 18 Dec 2003 11:50:46 -0500 (EST)
|
|