question about escaping

[Pavel Natov]

hi there   I'm still not sure about the problem that I have but here is the question:   I retrieve some data from Oracle database using ESQL logicsheet in a XSP file. <esql:results> <esql:row-results> <title><esql:get-string column="title"/></title> <subtitle><esql:get-string column="subtitle"/></subtitle> <text><esql:get-string column="content"/></text> <encoding><esql:get-ascii column="encoding"/></encoding> </esql:row-results> </esql:results>   The data retreived between <text> tags is XML alike (<doc><bold>blabla</bold></doc>). My purpose is to transform this data with XSLT and to produce html. When I use my XSLT to transform data from file(with custom xml data) there is no problem. The problem is when in my pipeline in the sitemap.xmap when I use  the same XSLT it does not match the tags retrieved from database because it escapes them with &lt;&gt;.Even when I make second transformation using <xsl:value-of select="." disable-output-escaping="yes"/> just to transform the text between <text></text> in xml it does not work. I produce this which would be ok if I save it to a file : <content> <title>   some title </title> <subtitle>  <bold>Some subtitle</bold> </subtitle> <text> <doc> <paragraphleft>   First paragraph   <italic>This is italic text</italic> </paragraphleft> <paragraphcenter>   Second paragraph <bold>This is bold text</bold> </paragraphcenter> </doc> </text> </content> But when I output it to a third transformation to make the actual HTML transformation it matches only tags defined in the first xsp (with esql tags). The tags between <text> are escaped with &lt;&gt; again. Anyway may be my method  is not working. HOw to retrieve XML data from database and not escape "<" ,">" I suppose that I'm not clear enough with my question but I could revision it.     Best regards/   ...................................................... Pavel Natov Systems Developer BIANOR 5 Stratsin Str. 1407 Sofia, Bulgaria Mobile: (+359 87) 658 049 Switchboard: (+359 2) 962 4564, (+359 2) 962 4574 Fax: (+359 2) 962 4416 mailto:[EMAIL PROTECTED] http://www.bianor.com ......................................................