This discussion is archived
0 Replies Latest reply: Oct 14, 2013 6:47 AM by Malc RSS

..how do you group fields together in xml into one field? (sql:- address_line1||', '||address_line2||', '|| )

Malc Newbie
Currently Being Moderated

afternoon Gurus.

 

I take it by the errror messages produced I'm not able to do this..

 

select ....

address_line1||', '|| address_line2||', '|| address_line3||', '|| city|| Supplier_Address

from...

 

..in my XML Publisher xsl Data Template file..

 

Caused by: org.xml.sax.SAXParseException: <Line 13, Column 20>: XML-20201: (Fatal Error) Expected name instead of |.

 

 

So how can I acheive putting several fields into one like you can in SQL?

 

THanksForLooking..

 

Al

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points