Sorry, I got it: current SQLTransformer doesn't queries on the same level.
So, I can't have: 

  <execute-query xmlns="http://apache.org/cocoon/SQL/2.0";> 
   <query name="materials">...   </query>

   <execute-query>
    <query name="facility"> ... </query>
   </execute-query>

   <execute-query>
    <query name="component"> ... </query>
   </execute-query>

  </execute-query>

thanx!

-----Original Message-----
From: Argyn Kuketayev [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 12:52 PM
To: '[EMAIL PROTECTED]'
Subject: two subqueries in sql transformer xml


I want to put two subqueries in xml file for sql transformer. It doesn't
work , says: "<error>ORA-00933: SQL command not properly ended</error> "


---------------------------------------------------------------------
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]>

Reply via email to