This would be so much easier if I actually *knew* SQL :-)
Thanks, that worked.
Heather
-Original Message-
From: Boris Goldowsky [mailto:[EMAIL PROTECTED]
Sent: 07 July 2008 18:14
To: users@cocoon.apache.org
Subject: Re: Using replace() function with SQL Transformer
Have you tried
Have you tried putting an "as" clause in the SQL?
SELECT COL1, COL2, REPLACE(COL3,'x','c') AS COL3, COL4 FROM
TABLE1 ...
Bng
On Mon, 2008-07-07 at 17:50 +0100, Heather Rankin wrote:
> Hi,
>
> Using SQL Transformer how do I get the result from a function - e.g.
> replace() - to appear within
Hi,
Using SQL Transformer how do I get the result from a function - e.g.
replace() - to appear within a specific tag in the XML results?
E.g.
I want:
SELECT COL1, COL2, REPLACE(COL3,'x','c'), COL4 FROM TABLE1 ...
to produce something like:
a
b
c
d
But what I'm getting (on COL3) is someth