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