|
[XML-DEV Mailing List Archive Home]
[By Thread]
[By Date]
[Recent Entries]
[Reply To This Message]
xslt simple question
|
Hi, sorry but I can't figure out the
xslt group and I know I can get a quick question here.
It's something common so I want to
know which is the best well-known approach.
Let's say I have:
<exported-data>
<department
name="accounting">
<member>
<name>foo</name>
</member>
<member>
<name>Peter</name>
</member>
</department>
<department
name="other">
....
</exported-data>
And I want to create an xslt
stylesheet to transform the XML into SQL statements for the tables:
department(id,name)
members(id,name,deptid)
I can assume the tables are
empty
Which is the best approach? obviously
the problem is dealing with ids, you have to mantain the id for each member of
the
department and "increment" ids as you
create new departments/ members.
Thanks!
Garland
|
|
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format
| RSS 2.0 |
 |
| Atom 0.3 |
 |
| |
Stylus Studio has published XML-DEV in RSS and ATOM formats,
enabling users to easily subcribe to the list from their preferred news reader application.
|
Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website.
they were not included by the author in the initial post. To view the content without the Sponsor Links please
click here.
|
|
Cart
