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">
<row>
<ID>1</ID>
<rowset name="F">
<row>
<f_name>f1</f_name>
<row>
...
</rowset>
<rowset name="C">
<row>
<c_name>c1</c_name>
<row>
....
</rowset>
</row>
...
</rowset>
I tried this :
<esq
l:parameter type="int"><esql:get-int ancestor="1"
column="id"/></esql:parameter>
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
Cocoon2?
thanks,
Argyn
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
