cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Argyn Kuketayev <Argyn.Kuketa...@plateau.com>
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">
  <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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message