Re: How to transform flat structure into hierarchical one?

Subject: Re: How to transform flat structure into hierarchical one?
From: Paul Tchistopolskii <paul@xxxxxxx>
Date: Wed, 07 Jun 2000 20:10:04 -0700
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


Current Thread