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 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=" 645 "> if I us a attribute. I think because of " " 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]
