cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Luca Morandini" <luca.morandi...@tin.it>
Subject RE: Returning result from two select statements in one file
Date Thu, 25 Apr 2002 09:38:34 GMT
Kurt,

I beg your pardon, but I haven't understood it yet... are you talking about
a sub-query or the processing of a cursor ?

May you just show us the query you've already tested ?

Best regards,

---------------------------------------------
               Luca Morandini
               GIS Consultant
              lmorandini@ieee.org
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------


> -----Original Message-----
> From: Hahn Kurt (CHA) [mailto:kurt.hahn@etat.ge.ch]
> Sent: Thursday, April 25, 2002 11:01 AM
> To: 'cocoon-users@xml.apache.org'
> Subject: RE: Returning result from two select statements in one file
>
>
> 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:luca.morandini1@tin.it]
> Envoye : jeudi, 25. avril 2002 10:01
> A : cocoon-users@xml.apache.org
> 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
>               lmorandini@ieee.org
> http://utenti.tripod.it/lmorandini/index.html
> ---------------------------------------------
>
>
> > -----Original Message-----
> > From: Hahn Kurt (CHA) [mailto:kurt.hahn@etat.ge.ch]
> > Sent: Thursday, April 25, 2002 9:26 AM
> > To: 'cocoon-users@xml.apache.org'
> > 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: <cocoon-users-unsubscribe@xml.apache.org>
> > For additional commands, e-mail: <cocoon-users-help@xml.apache.org>
> >
>
>
> ---------------------------------------------------------------------
> 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: <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail: <cocoon-users-help@xml.apache.org>
>
> ---------------------------------------------------------------------
> 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: <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail: <cocoon-users-help@xml.apache.org>
>


---------------------------------------------------------------------
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message