Kurt,
it seems to me more of an SQL than a Cocoon issue... may you share your
query with us ?
Best regards,
---------------------------------------------
Luca Morandini
GIS Consultant
[EMAIL PROTECTED]
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------
> -----Original Message-----
> From: Hahn Kurt (CHA) [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 25, 2002 9:26 AM
> To: '[EMAIL PROTECTED]'
> Subject: Returning result from two select statements in one file
>
>
> I'm developing a Cocoon application wich produces PDF files from a file
> which is generated by a DB access (Oracle). The problem is the query: The
> results I should get looks like this:
>
> <row>
> <field1>text</field1>
> ...
> <fieldN>text</fieldN>
> <field1FromSecondSelect>text</field1FromSecondSelect>
> ...
> <fieldNFromSecondSelect>text</fieldNFromSecondSelect>
> </row>
> where "fieldFromSecondSelect" are 0 or more rows which are returned and
> should be grouped with the main "select". In PL/SQL, I could
> write a stored
> procedure with a cursor that's returning me the second result set, but
> what's the way to do that in Cocoon? So far, I "succeeded" to
> write a select
> statement that's returning me all I need, but whenever the sub-select
> returns more than 1 row, the corresponding result from the main query is
> returned several times too, like this:
>
> <row>
> <field1>text</field1>
> ...
> <fieldN>text</fieldN>
> <field1FromSecondSelect>text</field1FromSecondSelect>
> </row>
>
> <row>
> <field1>same text again</field1>
> ...
> <fieldN>same text again</fieldN>
> <field2FromSecondSelect>text</field2FromSecondSelect>
> </row>
>
> <row>
> <field1>same text again</field1>
> ...
> <fieldN>same text again</fieldN>
> <field3FromSecondSelect>text</field3FromSecondSelect>
> </row>
>
> and so on. This means I would have to sort this multiple fields
> later, in a
> XSL, but that doesn't seem a very smart thing to do, I guess.
>
> Any suggestions?
>
> KH
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faqs.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/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
