You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@cocoon.apache.org by Tuomo L <tl...@cc.hut.fi> on 2004/06/17 11:51:53 UTC

SQL Transformer nested queries not working

When doing this:

<sql:execute-query>
  <sql:query>some query on 1st level...</sql:query>
  <sql:execute-query>
    <sql:query>some query on 2nd level...</sql:query>
  </sql:execute-query>
  <sql:execute-query>
    <sql:query>some other query on 2nd level...</sql:query>
  </sql:execute-query>
</sql:execute-query>

...the SQL-transformer outputs nothing. So, if there is  more than
one queries on some other level than the first one, nothing is created for
output.

Is there a way to get this working?

Cocoon 2.1.5

-Tuomo

Re: SQL Transformer nested queries not working

Posted by Vadim Gritsenko <va...@reverycodes.com>.

Tuomo L wrote:

>When doing this:
>
><sql:execute-query>
>  <sql:query>some query on 1st level...</sql:query>
>  <sql:execute-query>
>    <sql:query>some query on 2nd level...</sql:query>
>  </sql:execute-query>
>  <sql:execute-query>
>    <sql:query>some other query on 2nd level...</sql:query>
>  </sql:execute-query>
></sql:execute-query>
>
>...the SQL-transformer outputs nothing. So, if there is  more than
>one queries on some other level than the first one, nothing is created for
>output.
>  
>

IIRC, it's known issue.


>Is there a way to get this working?
>  
>

There is a patch in BugZilla...
  http://issues.apache.org/bugzilla/show_bug.cgi?id=17984
  http://issues.apache.org/bugzilla/show_bug.cgi?id=27440


Vadim