Tim,
thank you very much!
belongs on users. <- you are right (the first to dev was a mistake)
Tim Myers wrote:
Thorsten,
This message belongs on users.
You can't nest that way because as soon as you hit the nested execute-query
everything from the outer query is pushed onto a stack and is i
Thorsten,
This message belongs on users.
You can't nest that way because as soon as you hit the nested execute-query
everything from the outer query is pushed onto a stack and is inaccessible.
You need a int ap_id = before the
inner query begins and then use ap_id in the inner query
to recall
Scherler wrote:
leo leonid wrote:
(
or
are encoded CRs, AFAIK). So I'd recommend you strip
you DB column from these CRs and change the data type for this column
to INT)
Can you do that with normalize-space()?
On Montag, März 10, 2003, at 05:36 Uhr, Scherler, Thorsten wrote:
Hello group,
I
--Ursprüngliche Nachricht-
Von: leo leonid [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 10. März 2003 17:54
An: [EMAIL PROTECTED]
Betreff: Re: esql nested queries
try this:
---
/Leo
On Montag, März 10, 2003, at 05:36 Uhr, Scherler, Thorsten wrote:
Hello
EMAIL PROTECTED]
Gesendet: Montag, 10. März 2003 17:54
An: [EMAIL PROTECTED]
Betreff: Re: esql nested queries
try this:
---
/Leo
On Montag, März 10, 2003, at 05:36 Uhr, Scherler, Thorsten wrote:
Hello group,
I am using cocoon 2.0.4.
I tried the following the
Anyway,
how many ways for sql are there?
I found 3 different, what's the point in that?
I am confused (again!)
King regards
-Ursprüngliche Nachricht-
Von: Scherler, Thorsten
Gesendet: Montag, 10. März 2003 18:12
An: Cocoon-Users (E-Mail)
Betreff: AW: esql nested queries
Hell
PROTECTED]
Gesendet: Montag, 10. März 2003 17:54
An: [EMAIL PROTECTED]
Betreff: Re: esql nested queries
try this:
---
/Leo
On Montag, März 10, 2003, at 05:36 Uhr, Scherler, Thorsten wrote:
> Hello group,
>
> I am using cocoon 2.0.4.
>
> I tried
30 mei 2002 15:46
Onderwerp: Antw: Re: ESQL-Nested Queries
Hello Christian,
as far as I could say, I get a ResultSet with the REFCURSOR in it, but I'm
not able to dereferenz on this cursor to access its fields. I have tried
with different methods (getArray(), getObject() casted to Resu
Hello Christian,
as far as I could say, I get a ResultSet with the REFCURSOR in it, but I'm not able to
dereferenz on this cursor to access its fields. I have tried with different methods
(getArray(), getObject() casted to ResultSet, ...) but it doesn't seem to make any
difference.
I just sw
On 30.May.2002 -- 10:45 AM, Malte Vahlenkamp wrote:
> Hello,
>
> I'm using Cocoon 2.02 and need some help with esql. I'm trying to access a resultset
>the column of another resultset returned by my query, but I don't get it running.
>DBMS is Oracle 9i and the return value of f_searchentries is
Hello,
I'm using Cocoon 2.02 and need some help with esql. I'm trying to access a resultset
the column of another resultset returned by my query, but I don't get it running. DBMS
is Oracle 9i and the return value of f_searchentries is a refcursor. The
select-statement works correctly in the sq
> Although you have to write a bit of Java, it is minimal.
that's what I want to avoid. I'm trying to work out the way to design a
reporting module, so that report developer don't have to mess with Java.
> The only puzzling thing is you state at the beginning that
> you need to do
> this for e
TH
Perry
-Original Message-
From: Argyn Kuketayev [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 26 March 2002 4:30
To: '[EMAIL PROTECTED]'
Subject: Cocoon2: ESQL nested queries optimization
> I've to make a report on the table M, then for each row I
> need to show corres
> I've to make a report on the table M, then for each row I
> need to show corresponding rows from tables F and C.
>
> Something like this:
>
>
>
> 1
>
>
>
> f1
>
> ...
>
>
>
>
> c1
>
>
>
>
> .
I'm trying to find the best way to organize my XML data before doing the XSL
stylesheet, and wanted to create my queries using ESQL nesting like this:
select foo from bar
select foo1 from bar1 where id = a (where
"a" id from "ancestor=1" query just be
15 matches
Mail list logo