html out of a db (Cocoon 1.8.1, Tomcat, Postgresql)

[Schroeter Christian <Ch...@nbg.sbs.de>]

Hi,

i want to read out of my database the content of my html-pages.

unfortunatly every < and > are replaced by &lt; anf &gt;

So the browser is printing the html code and not interpreting it.

Can anybody help me?
What must i change?

cu,
christian schroeter 


My sourcecode:

XML-File
<?xml version="1.0"?>
<?cocoon-process type="xsp"?>
<?cocoon-process type="xslt"?>
<?xml-stylesheet type="text/xsl" href="OK.xsl"?>
<xsp:page
   xmlns:xsp="http://www.apache.org/1999/XSP/Core"
   xmlns:esql="http://apache.org/cocoon/SQL/v2"
   xmlns:request="http://www.apache.org/1999/XSP/Request">
<page>
....
<esql:connection>
               <esql:pool>drm</esql:pool>
                  <esql:execute-query>
                     <esql:query>
                        select * from html
                     </esql:query>
                     <esql:results>
                        <esql:row-results>
                              <html><esql:get-string column="html"/></html>
                              <xhtml><esql:get-xml column="html"/></xhtml>
                        </esql:row-results>
                     </esql:results>
                     <esql:error-results>
                        <error>
                           <ort>selectHTML</ort>
                           <message>
                              <esql:get-message/>
                           </message>
                        </error>
                     </esql:error-results>
                  </esql:execute-query>
            </esql:connection>	
...
</page>
</xsp:page>

XSL-File:

<?xml version="1.0"?>
<xsl:stylesheet
   xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
   xmlns:util="http:://www.apache.org/1999/XSP/Util"
   xmlns:xsp="http://www.apache.org/1999/XSP/Core" version="1.0">
   <xsl:template match="/page">
	<html>
	<body>
		<xsl:value-of select="html"/>
		<xsl:value-of select="xhtml"/>
	</body>
	</html>
   </xsl:template>

<

---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>