R: Cocoon SQL Transformation

2002-10-29 Thread Luca Morandini
] Subject: R: Cocoon SQL Transformation Tom, I guess your pipeline contains a couple XSLT transformations and a couple SQL ones (one for the select, one for the insert), isn't it ? If this is true, could you please send me the XML which is sent to the failing transformation (be it SQL or XSLT

Cocoon SQL Transformation

2002-10-28 Thread Tom Place
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

Re: Cocoon SQL Transformation

2002-10-28 Thread Bert Van Kets
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 +, you wrote: Hi all, Quick question to do with the way the cocoon SQL parser copes with

R: Cocoon SQL Transformation

2002-10-28 Thread Luca Morandini
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

RE: Cocoon SQL Transformation

2002-10-28 Thread Tom Place
: 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

R: Cocoon SQL Transformation

2002-10-28 Thread Luca Morandini
Tom, could you post the XML document that fails ? Best regards, Luca Morandini [EMAIL PROTECTED] -Messaggio originale- Da: Tom Place [mailto:psyttrp;nottingham.ac.uk] Inviato: lunedì 28 ottobre 2002 15.38 A: [EMAIL PROTECTED] Oggetto: RE: Cocoon SQL Transformation I have tried

RE: Cocoon SQL Transformation

2002-10-28 Thread Tom Place
/xsl:template /xsl:stylesheet -Original Message- From: Luca Morandini [mailto:spectrum.morandini;ipzs.it] Sent: 28 October 2002 14:45 To: [EMAIL PROTECTED] Subject: R: Cocoon SQL Transformation Tom, could you post the XML document that fails ? Best regards, Luca Morandini

RE: Cocoon SQL Transformation

2002-10-28 Thread Tom Place
/execute-query titleBlah 2/title /xsl:otherwise /xsl:choose /page /xsl:template /xsl:stylesheet -Original Message- From: Luca Morandini [mailto:spectrum.morandini;ipzs.it] Sent: 28 October 2002 15:27 To: [EMAIL PROTECTED] Subject: R: Cocoon SQL