I don't see a customer id element or attribute in the sample source XML you
provided. How will you uniquely identify each customer?
--
Charles Knell
cknell(_at_)onebox(_dot_)com - email
-----Original Message-----
From: Brandon Schenz <brandons(_at_)midwestsports(_dot_)com>
Sent: Fri, 24 Sep 2004 10:50:09 -0400
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: Re: [xsl] "FLAT" XML to Hierarchical XML
well, to be honest I am a newbie here (Like you couldn't tell that), and
I'm using VB.NET (please don't make too much fun of me). I'm honestly
not sure what a .NET DataSet would do with that, and regardless when I
dump these in my database I need to associate a CustomerID to an Order
and an OrderID to each LineItem. Your format will work fine for me as
long as I'm able to add a unique orderID (I suppose that that is given
to me in the original XML file though), and a unique customerID.
*Brandon Schenz*
Midwest Sports Supply
Phone: 513-956-4900
Fax: 513-956-4910
E-mail: brandons(_at_)midwestsports(_dot_)com
cknell(_at_)onebox(_dot_)com wrote:
I don't see the hierarchy in the output you say you want. All the
customers are in one element, all the orders are in a sibling element,
and all the order details go into a third sibling. Is this really the
format you want? When you said you wanted to make the format
hierarchical, I imagined that you wanted to group all the items by
order and all the orders by customer, something like this:
<customer>
<orders>
<order>
<line-item></line-item>
</order>
</orders>
</customer>
--+------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--+--