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]>
