[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: make recursive call

Subject: Re: make recursive call
From: "mary liu" <maryliu99@xxxxxxxxx>
Date: Mon, 11 Sep 2006 15:47:20 -0400
mary liu
Sorry, I am unable to provide a solution with the present problem
description. You need to explain more clearly.

On 9/8/06, mary liu <maryliu99@xxxxxxxxx> wrote:
Thanks Mukul! It is very helpful.


Another question is if I have exception data, like the last 2 records. I want to genterate like newxml.xml.

oldxml.xml


<ResultSet> <data_service> <Employeeprofile> <row emp_name="one" org_cd="73700" rpt_to_org_cd="11111" lev="2" /> <row emp_name="four" org_cd="73656" rpt_to_org_cd="73700" lev="3" /> <row emp_name="five" org_cd="75425" rpt_to_org_cd="73700" lev="3" /> <row emp_name="three" org_cd="73723" rpt_to_org_cd="11111" lev="2" /> <row emp_name="two" org_cd="73708" rpt_to_org_cd="11111" lev="2" /> <row emp_name="Six" org_cd="73651" rpt_to_org_cd="73708" lev="3" /> <row emp_name="Seven" org_cd="73632" rpt_to_org_cd="73651" lev="4" /> <row emp_name="Eight" org_cd="73229" rpt_to_org_cd="73651" lev="4" /> <row emp_name="nine" org_cd="74023" rpt_to_org_cd="73651" lev="4" /> <row emp_name="ten" org_cd="73989" rpt_to_org_cd="11111" lev="2" />


<row emp_name="eleven" org_cd="897750" rpt_to_org_cd="UHFH" lev="4" /> <row emp_name="twelve" org_cd="3334" rpt_to_org_cd="4456" lev="2" /> </Employeeprofile> </data_service> </ResultSet>


the newxml.xml


So the newxml.xml should be like this:


<ResultSet> <branch id="one"> <branchText>one</branchText> <leaf> <leafText>four</leafText> </leaf> <leaf> <leafText>five</leafText> </leaf> </branch>


<branch id="three"> <branchText>three</branchText> </branch>


<branch id="two"> <branchText>two</branchText> <branch id="Six"> <branchText>Six</branchText> <leaf> <leafText>Seven</leafText> </leaf> <leaf> <leafText>Eight</leafText> </leaf> <leaf> <leafText>nine</leafText> </leaf> </branch> </branch>


<branch id="ten"> <branchText>ten</branchText> </branch>


<branch id="eleven"> <branchText>eleven</branchText> </branch>


<branch id="twelve"> <branchText>twelve</branchText> </branch> </ResultSet>


why this exception happened? it is because the database returned those records, we don't know how comes, but we still want to keep those exception data in the first level, no matter what are those excetion data levels? the convert xsl you wrote, can't display those data, ( can display lev =2) The exception data have not any relationship with the root. The lev number may be 2 or 3, or maybe 4 or ..., lev=2 we can display, but the others data,Can we make it? Is it possible to write the condition call those data?

Thanks in advance.

Mary

Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.