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
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
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
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,
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
: 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/
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
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
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";>