It is not really an issue about SQL, but the question is how I do in Cocoon what I normally would have to do in a stored procedure: Simply, I can not execute one query to get all my results, I need two select statements that are dependent on each other in order to get the combined result. Is there a possibility to do that? It looks as if map:aggregate is useful only if the two queries are independent, but they aren't. Example: The first select returns a row, and dependent on the result of that row, a second select returns zero, one ore more rows that should be added to the first returned row (as if they belonged to the result from the first select..).
Is that understandable? KH -----Message d'origine----- De : Luca Morandini [mailto:[EMAIL PROTECTED]] Envoye : jeudi, 25. avril 2002 10:01 A : [EMAIL PROTECTED] Objet : RE: Returning result from two select statements in one file 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]> --------------------------------------------------------------------- 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]>