Subject: Re: [xsl] 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 |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] filtering XML file using , David Carlisle | Thread | Re: [xsl] filtering XML file using , David Carlisle |
Re: [xsl] filtering XML file using , David Carlisle | Date | Re: [xsl] filtering XML file using , David Carlisle |
Month |