Re: Returning result from two select statements in one file

2002-04-26 Thread Conny Pemfors
pril 26, 2002 10:22 AM Subject: RE: Returning result from two select statements in one file > Thanks to everyone. I got a lot of answers, the simplest solution was just > to send a nested query, there was a very comprehensive section in the User > Guide. > >

RE: Returning result from two select statements in one file

2002-04-26 Thread Hahn Kurt (CHA)
Thanks to everyone. I got a lot of answers, the simplest solution was just to send a nested query, there was a very comprehensive section in the User Guide. The C2 community is great!!! Kurt - Please check that your question ha

Re: Returning result from two select statements in one file

2002-04-25 Thread Christian Haul
On 25.Apr.2002 -- 09:25 AM, Hahn Kurt (CHA) wrote: > 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: > > > text > ... > text > text > ... > text > You are

Re: Returning result from two select statements in one file

2002-04-25 Thread KOZLOV Roman
[EMAIL PROTECTED] > http://utenti.tripod.it/lmorandini/index.html > ----------------- > > > -----Original Message- > > From: Hahn Kurt (CHA) [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, April 25, 2002 11:01 AM > > To: '[EMAI

RE: Returning result from two select statements in one file

2002-04-25 Thread Luca Morandini
n Kurt (CHA) [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 25, 2002 11:48 AM > To: '[EMAIL PROTECTED]' > Subject: RE: Returning result from two select statements in one file > > > That's a good suggestion. I'll try that! > > -Message d'

RE: Returning result from two select statements in one file

2002-04-25 Thread Hahn Kurt (CHA)
That's a good suggestion. I'll try that! -Message d'origine- De : Bertrand Delacretaz [mailto:[EMAIL PROTECTED]] Envoye : jeudi, 25. avril 2002 11:46 A : [EMAIL PROTECTED] Objet : Re: Returning result from two select statements in one file Salut Kurt, On Thursday 25 A

Re: Returning result from two select statements in one file

2002-04-25 Thread Bertrand Delacretaz
Salut Kurt, On Thursday 25 April 2002 11:00, Hahn Kurt (CHA) wrote: >. . . > 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

RE: Returning result from two select statements in one file

2002-04-25 Thread Hahn Kurt (CHA)
ndini [mailto:[EMAIL PROTECTED]] Envoye : jeudi, 25. avril 2002 11:39 A : [EMAIL PROTECTED] Objet : RE: Returning result from two select statements in one file 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 y

RE: Returning result from two select statements in one file

2002-04-25 Thread Luca Morandini
age 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

RE: Returning result from two select statements in one file

2002-04-25 Thread Hahn Kurt (CHA)
urned 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 i

Re: Returning result from two select statements in one file

2002-04-25 Thread Bertrand Delacretaz
On Thursday 25 April 2002 09:25, Hahn Kurt (CHA) wrote: > . . .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? >. . . An alternative would be to process the two SELECT independently, each with thei

RE: Returning result from two select statements in one file

2002-04-25 Thread Luca Morandini
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 -