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()? <esql:get-int column="normalize-space(ap_id)"/>
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:execute-query> <esql:query> select * from ap_tab where ap_id =<esql:get-int column="ap_id"/> </esql:query>
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"/> ?
You cannot apply an arbitrary function to logicsheet attributes. You should try to distinguish the different phases and tools that are orchestrated to accomplish serving an XSP.
You might want to look up the functions your DBMS provides for comparing strings.
You cannot use <esql:get..../> inside an <esql:query/> UNLESS it is surrounded by an <esql:parameter/> OR the query is an <xsp:expr/> and composed of java strings.
You need to use the ancestor attribute to refer to a result from outside this <esql:execute-query/>
You need to search the list and docs for examples. This has been up before, actually, only a couple of hours ago.
You should add to wiki.cocoondev.org to share your new knowledge.
HTH
Chris.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
