Hi, Using SQL Transformer how do I get the result from a function - e.g. replace() - to appear within a specific <sql> tag in the XML results? E.g.
I want: SELECT COL1, COL2, REPLACE(COL3,'x','c'), COL4 FROM TABLE1 ... to produce something like: <sql:rowset> <sql:row> <sql:col1>a</sql:col1> <sql:col2>b</sql:col2> <sql:col3>c</sql:col3> <sql:col4>d</sql:col4> </sql:row> But what I'm getting (on COL3) is something like: <sql:rowset> <sql:row> <sql:col1>a</sql:col1> <sql:col2>b</sql:col2> <sql:replace(COL3,'x','c')>...</sql:replace> ... Could I use <sql:out-parameter> here somehow? http://www.bbc.co.uk/ This e-mail (and any attachments) is confidential and may contain personal views which are not the views of the BBC unless specifically stated. If you have received it in error, please delete it from your system. Do not use, copy or disclose the information in any way nor act in reliance on it and notify the sender immediately. Please note that the BBC monitors e-mails sent or received. Further communication will signify your consent to this. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
