Well you could probably write another transformer (to be placed after the SQLTransformer in the pipeline) that would change the escaped charactors into < > ... It could also look for the second <?xml version="1.0"?> and not pass it through. That's kind of brutal coding IMO.
Another option may be XSP with the util stylesheet. You'd have to look into the email lists for examples. The one issue with it also is that everything must be on the same line so you don't get line feed charactor return stuff. Beyond that it works nice. your call. I use the XSP/util tags myself for including XML fragments. As well as XSP to access the database. So you may also want to think if you want to do the database actions vs XSP ESQL first and then write a transformer vs using XSP UTIL tags to include the XML into your outputted XML. Some like do db actions and others use XSP... but that may dictate your solution for including XML. MD --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>