Niels, I ran into the same problem.
Did you ever get an answer or were you able to figure it out yourself? Regards, Torsten > Is it possible to have more than one ancestor query in the input XML for > the SQLTransformer? I don't see any reason why it shouldn't be, but I > cannot get it to work. > > Example: > > The query > > <page xmlns:sql="http://apache.org/cocoon/SQL/2.0";> > <sql:execute-query> > <sql:query name="person"> > select id, name, email, frequency from person; > </sql:query> > <sql:execute-query> > <sql:query name="themes"> > select theme > from person_theme > where personid = <sql:ancestor-value sql:level="1" > sql:name="person.id"/>; > </sql:query> > </sql:execute-query> > <sql:execute-query> > <sql:query name="types"> > select type > from person_type > where personid = <sql:ancestor-value sql:level="1" > sql:name="person.id"/>; > </sql:query> > </sql:execute-query> > </sql:execute-query> > </page> > > returns > > <page xmlns:sql="http://apache.org/cocoon/SQL/2.0";></page> > > while > > <page xmlns:sql="http://apache.org/cocoon/SQL/2.0";> > <sql:execute-query> > <sql:query name="person"> > select id, name, email, frequency from person; > </sql:query> > <sql:execute-query> > <sql:query name="themes"> > select theme > from person_theme > where personid = <sql:ancestor-value sql:level="1" > sql:name="person.id"/>; > </sql:query> > </sql:execute-query> > </sql:execute-query> > </page> > > returns the result of the SQL queries as it should. > > Is this functionality simply not supported by the SQLTransformer, or is my > input XML incorrect? Maybe I misinterpreted the meaning of the level > attribute? > > Niels > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
