472,145 Members | 1,304 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

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
0 1945

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

16 posts views Thread by datactrl | last post: by
3 posts views Thread by Bruno Paquette | last post: by
1 post views Thread by needin4mation | last post: by
reply views Thread by Saiars | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.