R: Cocoon SQL Transformation

2002-10-29 Thread Luca Morandini
in matched ones ("'" --> "''") before sending SQL statements to the SQLTransformer. Luca Morandini [EMAIL PROTECTED] > -Messaggio originale- > Da: Tom Place [mailto:psyttrp@;nottingham.ac.uk] > Inviato: lunedì 28 ottobre 2002 18.19 > A

RE: Cocoon SQL Transformation

2002-10-28 Thread Tom Place
Blah 2 -Original Message- From: Luca Morandini [mailto:spectrum.morandini@;ipzs.it] Sent: 28 October 2002 15:27 To: [EMAIL PROTECTED] Subject: R: Cocoon SQL Transformation Tom, I guess your pipeline contains a couple XSLT transformations and a coup

R: Cocoon SQL Transformation

2002-10-28 Thread Luca Morandini
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) ? I'm interested in the actual XML docume

RE: Cocoon SQL Transformation

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

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 Transfo

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: http://apache.org/cocoon/SQL/2.0";> insert into my_table (Col1, Col2) values ('1', '2') http://apache.org/cocoon/SQL/

R: Cocoon SQL Transformation

2002-10-28 Thread Luca Morandini
insert into my_table (Col1, Col2) values ('2', '3') 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

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 multipl

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: http://apache.org/cocoon/SQL/2.0";>