cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Argyn Kuketayev <>
Subject Cocoon2: couldn't make nested queries work for ESQL in XSP.
Date Mon, 25 Mar 2002 15:34:08 GMT
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:

<rowset name="M">

    <rowset name="F">    

    <rowset name="C">    

I tried this :

l:parameter type="int"><esql:get-int ancestor="1"

It didn't work with an exception: 

org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): java.lang.RuntimeException: Error executing
prepared statement: select ... from f where M_ID = ? :
java.sql.SQLException: ORA-01722: invalid number

Can somebody give me a WORKING and tested example of nested queries in


Please check that your question has not already been answered in the
FAQ before posting. <>

To unsubscribe, e-mail: <>
For additional commands, e-mail: <>

View raw message