Re: How to transform flat structure into hierarchical one?

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