Argyn,
oh, I see...
In such a case I'd make a nice XSL to convert the query results to the
format I like (I've posted such an XSL some time ago).
Anyway, I can see the rationale. The point is that SQL produces rowset
(inherently NOT hierarchycal), while XML is strongly hierarchycal.
I presume there is scope for making a Transformer, which would make
hierarchycal rowsets from "flat" ones... anyone interested ?
Best regards,
---------------------------------------------
Luca Morandini
GIS Consultant
[EMAIL PROTECTED]
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------
> -----Original Message-----
> From: Argyn Kuketayev [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 21, 2002 6:56 PM
> To: '[EMAIL PROTECTED]'
> Subject: RE: SQLTransformer, multiple execute-query siblings?
>
>
> suppose you want to have this xml:
>
> <P>
> <row1>
> <p-name/><p-address/>
> <c1>
> <row1><c1-name/></row1>
> <row2>......
> </c1>
> <c2>
> <row1><c2-name/></row1>
> <row2>......
> </c2>
> </row1>
> <row2>
> .....
>
> </P>
>
>
> here, P-parent, c1, c2 - children
> > -----Original Message-----
> > From: Luca Morandini [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, June 21, 2002 12:49 PM
> > To: [EMAIL PROTECTED]
> > Subject: RE: SQLTransformer, multiple execute-query siblings?
> >
> >
> > Jens,
> >
> > I beg your pardon, but, what's the use of having such nested queries ?
> >
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail: <[EMAIL PROTECTED]>
>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
