it doesn't support two nested queries on the same level of nesting, as far
as I remember after looking at C2.0.1 sources. I don't think it's fixed.
Workaround is:
1. modify source codes
2. use XSP
I use XSP with ESQL
Can someone confirm this, and is there a workaround other
than chaining
:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 10:28 AM
To: '[EMAIL PROTECTED]'
Subject: RE: SQLTransformer, multiple execute-query siblings?
it doesn't support two nested queries on the same level of
nesting, as far as I remember after looking at C2.0.1
sources. I don't think it's
- Original Message -
From: Argyn Kuketayev [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 21, 2002 4:27 PM
Subject: RE: SQLTransformer, multiple execute-query siblings?
it doesn't support two nested queries on the same level of nesting, as
far
as I remember after looking
the stack. I don't remember all the details though
-Original Message-
From: Jens Lorenz [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 10:40 AM
To: [EMAIL PROTECTED]
Subject: Re: SQLTransformer, multiple execute-query siblings?
The problem is, that it's not that easy. Transformer
Bertrand,
could, just possibly, a sub-select fit the bill ?
something like:
SELECT Name
FROM Employee
WHERE Ssn IN (
SELECT DISTINCT PMSsn
FROM Projects
WHERE Status = 'open'
)
Best regards,
- Original Message -
From: Jens Lorenz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 21, 2002 4:40 PM
Subject: Re: SQLTransformer, multiple execute-query siblings?
From: Argyn Kuketayev [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 21, 2002 4:27 PM
Subject
-
-Original Message-
From: Jens Lorenz [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 6:19 PM
To: [EMAIL PROTECTED]
Subject: Re: SQLTransformer, multiple execute-query siblings?
- Original Message -
From: Jens Lorenz [EMAIL PROTECTED
Your example shows that it's possible to have one nested query inside
another one. But it doesn't show that you may have sibling nested queries.
as far as I remember, you can have only one child (nested query), but that
child can have one child too and so on. you can't have this:
page
: Friday, June 21, 2002 12:49 PM
To: [EMAIL PROTECTED]
Subject: RE: SQLTransformer, multiple execute-query siblings?
Jens,
I beg your pardon, but, what's the use of having such nested queries ?
-
Please check that your
/lmorandini/index.html
-
-Original Message-
From: Argyn Kuketayev [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 6:56 PM
To: '[EMAIL PROTECTED]'
Subject: RE: SQLTransformer, multiple execute-query siblings?
suppose you want to have
10 matches
Mail list logo
