This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
Re: How to transform flat structure into hierarchical one?
- To: xsl-list at mulberrytech dot com
- Subject: Re: How to transform flat structure into hierarchical one?
- From: Paul Tchistopolskii <paul at qub dot com>
- Date: Wed, 07 Jun 2000 20:10:04 -0700
- Organization: The Qub Group
- References: <422568F6.00673C03.00@amadeus.tech.swh.lv>
- Reply-To: xsl-list at mulberrytech dot com
From: Aleksandrs Jakovlevs
> BTW, I don't understand how SQL can return me anything else than the
> flat structure I have described).
If you are using Oracle and you are not afraid of writing some tricky
queries, you can get hierarchical XML out of SQL using some proprietary
( not obvious ) Oracle tricks with cursor.
If you want something simple and obvious running with any SQL server,
you can take a look at http://www.pault.com/Pxsl.
PXSLServlet allows you to get hierarchical XML out of SQL and
then pass generated XML into XSLT transformation.
Rgds.Paul.
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list