Tom, every "query" element should live within a separate "execute-query" one, like in:
<execute-query xmlns="http://apache.org/cocoon/SQL/2.0"> <query> insert into my_table (Col1, Col2) values ('1', '2') </query> </execute-query> <execute-query xmlns="http://apache.org/cocoon/SQL/2.0"> <query> insert into my_table (Col1, Col2) values ('2', '3') </query> </execute-query> I suppose you've already try this... then, what's the error you get ? Best regards, Luca Morandini [EMAIL PROTECTED] > -----Messaggio originale----- > Da: Tom Place [mailto:psyttrp@;nottingham.ac.uk] > Inviato: luned́ 28 ottobre 2002 14.27 > A: [EMAIL PROTECTED] > Oggetto: Cocoon SQL Transformation > > > 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]> > We are protected from the virus by Norton Antivirus Corporate Edition --------------------------------------------------------------------- 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]>