Hi i try to get a value with a query, and then use this value in more than one nested queries but i dont see record in my database. BTW i dont get any error message.
when i have only one nested sql query that use a ancestor value then everything work fine this code describe what i try to do: <page xmlns:sql="http://apache.org/cocoon/SQL/2.0";> <content> <para>This is a SQL batch file</para> <execute-query xmlns="http://apache.org/cocoon/SQL/2.0";> <query name="parentid"> select maxid from qMaxElementId </query> <execute-query> <query name="insertchild"> INSERT INTO tblElements(element_Parent,element_title,element_description) VALUES('<ancestor-value sql:name="maxid" sql:level="1"/>', 'child 1, 'this is the first child') </query> </execute-query> <execute-query> <query name="insertchild2"> INSERT INTO tblElements(element_Parent,element_title,element_description) VALUES('<ancestor-value sql:name="maxid" sql:level="2"/>', 'child 2', 'this is the second child') </query> </execute-query> </execute-query> </content> </page> is something that i do wrong or just this functionality does not supported from SQL transformer? thnx --stavros --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
