467,161 Members | 889 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,161 developers. It's quick & easy.

cocoon 2.1.6 xsp page: problem with <esql:get-string> and <esql:get-xml>

I want to display a MySQL database field that can contain HTML markup.
If I use <esql:get-string> then I get all of the database field, but
all tags are escaped which is not what I want. If I use <esql:get-xml>
the tags are not escaped, but only the first part of the database
field is displayed.

The content of the database field is:

"<h1>Title</h1><h2>Subtitle</h2>"

Here is my xsp page:

<?xml version="1.0" encoding="ISO-8859-1"?>

<xsp:page language="java"
xmlns:xsp="http://apache.org/xsp"
xmlns:esql="http://apache.org/cocoon/SQL/v2"


<page>

<title>Test</title>

<content>

<esql:connection>
<esql:pool>abc</esql:pool>
<esql:execute-query>
<esql:query>
select * from blocks
</esql:query>
<esql:results>
<text>
<esql:row-results>
<esql:get-string column="block"/>
</esql:row-results>
</text>
</esql:results>
</esql:execute-query>
</esql:connection>

</content>
</page>

</xsp:page>

This xsp page generates:
....
<text>
&lt;h1&gt;Title&lt;/h1&gt;&lt;h2&gt;Subtitle&lt;/h2&gt;
</text>
....

When I use <esql:get-xml column="block"/> then the output changes to:

....
<text>
<h1>Title</h1>
</text>
....

Note that the "Subtitle" string is gone. Why? What can I do to get all
of the database field in the xml output?
Jul 20 '05 #1
  • viewed: 1802
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Bruno Paquette | last post: by
1 post views Thread by needin4mation@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.