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