hi guys
This mail doesnt directly involve tomcat.. Please excuse.
For our content management we are storing all the xml content in a
database text column.
We are using cocoon for rendering xml documents to HTML.
According to our original thoughts we were thinking that using XSP tags in
a temporary xml file we could pull the particular xml document from the database
column
and after that cocoon should render it using the supplied xsl transformation rules.
The sample temporary file is attched below
However things didnt quite happen the way we predicted as cocoon escapes
all the tag elements..
Could u please provide me with some solution to this problem..
Thanx
Anand Raman
<?xml version="1.0"?>
<?cocoon-process type="xsp"?>
<?cocoon-process type="xslt"?>
<?xml-stylesheet href="page-html.xsl" type="text/xsl"?>
<xsp:page
language="java"
xmlns:sql="http://www.apache.org/1999/SQL"
xmlns:xsp="http://www.apache.org/1999/XSP/Core"
>
<page>
<title>News Now</title>
<author>
<name>Amit Kaushik</name>
<address>[EMAIL PROTECTED]</address>
</author>
<xsp:expr>request.getQueryString()</xsp:expr>
<sql:execute-query>
<sql:driver>org.postgresql.Driver</sql:driver>
<sql:dburl>jdbc:postgresql://localhost/newztoday</sql:dburl>
<sql:username>FOO</sql:username>
<sql:password>BAR</sql:password>
<sql:row-element>options</sql:row-element>
<sql:tag-case>lower</sql:tag-case>
<sql:null-indicator>yes</sql:null-indicator>
<sql:id-attribute>ID</sql:id-attribute>
<sql:id-attribute-column>foo_id</sql:id-attribute-column>
<sql:query>select xml_story from content where news_id=(select
max(news_id) from content)</sql:query>
<sql:count-attribute>count</sql:count-attribute>
</sql:execute-query>
</page>
</xsp:page>
