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