I have tried it like you say however am still getting an internal server error:
org.apache.cocoon.ProcessingException: Exception during processing of file:/C:/tomcat/webapps/cocoon/autorevs/docs/doregister.xml: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.NullPointerException The page will run with the sql commented out so that’s not the problem and the sql actually does insert into the db, but then you get the above! Tom -----Original Message----- From: Luca Morandini [mailto:spectrum.morandini@;ipzs.it] Sent: 28 October 2002 14:06 To: [EMAIL PROTECTED] Subject: R: Cocoon SQL Transformation 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]> --------------------------------------------------------------------- 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]>