I can't help you with your problem, but I can tell you that I am using esql in an XSP with this. It works flawlessly when calling multiple queries one after the other.

Bert

At 13:26 28/10/2002 +0000, you wrote:
Hi all,

Quick question to do with the way the cocoon SQL parser copes with
multiple SQL statements.
There is probably a very quick fix for this but I'm tearing my hair out
trying to find it!

When inserting using and SQL statement based in XSL like so:

<execute-query xmlns="http://apache.org/cocoon/SQL/2.0";>
  <query>
    insert into my_table (Col1, Col2) values ('1', '2')
  </query>
</execute-query>

This is fine, but when you want to add a second it wont do it!
I have tried with a second set of <execute-query> tags, I have tried
putting a second set of <query> tags within an <execute-query>

Any Ideas?

Cheers
Tom


---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

Reply via email to