Re: AW: esql nested queries

[Scherler]

leo leonid wrote:

It looks like you stored your 'ap_id's enclosed within two carriage 
returns.
(
 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()?
<esql:get-int column="normalize-space(ap_id)"/>
/Leo



On Montag, März 10, 2003, at 06:12  Uhr, Scherler, Thorsten wrote:

Hello Leo,

it is not working either.

But I think I know why that happends:
in my source code there is the following:
<client ap_id="&#10;645&#10;">
if I us a attribute.
I think because of "&#10;" I get no match for the second query!

Can that be?

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

<esql:get-int column="ap_id" ancestor="1"/>
                              -----------
/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 nested esql (not working):

<esql:connection>
<esql:pool>INSTA</esql:pool>
<esql:execute-query>
<esql:query>
         select * from xml_verkauf
         </esql:query>
<esql:results>
<esql:row-results>
<data>
<client>
<ep1>
<esql:get-int column="ap_id"/>
</ep1>
</client>
<aps>
<esql:execute-query>
<esql:query>
                  select * from ap_tab where ap_id =<esql:get-int
column="ap_id"/>
</esql:query>
<esql:results>
<esql:row-results>
<ap>
<esql:get-columns/>
</ap>
</esql:row-results>
</esql:results>
<esql:no-results><no-results/></esql:no-results>
<esql:error-results/>
</esql:execute-query>
</aps>
</data>
</esql:row-results>
</esql:results>
<esql:no-results/>
<esql:error-results/>
</esql:execute-query>
</esql:connection>
As soon as I change
...
                  select * from ap_tab where ap_id =1
 I can nest the query!
Why can I not use <esql:get-int column="ap_id"/>     ?

King regards

Mit freundlichem Gruss,

Thorsten Scherler
Marketing / Telefonmarketing
Weidmüller GmbH & Co.
P.O. Box 2807
33058 Paderborn
Tel.:+ 49 - 5252-960-350
Fax:+ 49 - 5252-960-116
eMail: [EMAIL PROTECTED]
http://www.weidmueller.de




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]