Hi, I want to obtain an xml mixed content using <esql:get-xml>. I add n root element but I would like to set a namespace for it. Unfortunately it doesn't work by adding only prefix. I can't leave root in namespace with empty prefix, because the xml in DB is without prefix too, which causes namespace mismatch.
------------ Here is an examlple: a column "test" in DB: "some <tag>example</tag> of get-xml" 1. If I put a XSP like this: <esql:get-xml column="test" root="root"/> I obtain an namespace missmatch: <root>some <tag>example</tag> of get-xml</root> 2. Put root outside "get-xml" <ns:root><esql:get-xml column="test"/></ns:root> I obtain an empty root, because the source has mixed content: <ns:root></ns:root> 3. Put prefixed root name: <esql:get-xml column="test" root="ns:root"/> Results in completely empty output, without even an error. ---------- How can I solve it? Regards, Marcin Okraszewski --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
