cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Russell Castagnaro <>
Subject [C2] Accessing CLOBs as Documents
Date Thu, 18 Oct 2001 16:47:50 GMT
Hello cocoon-users,

  I've got a problem.

  I have a table that has a few fields and a clob in it.  I want to
  use the esql taglibs or SQLTransfromer to access this as a document.
  The column 'doc_content' is

  currently I'm using xml like this:

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


   <title>A Database XML DOC Page</title>

       <esql:query>Select * from XML_DOC where doc_id in (select max(doc_id) from xml_doc)
            <doc_id><esql:get-string column="doc_id"/></doc_id>

           <doc_content><esql:get-ascii column="doc_content"/></doc_content>


the 'doc_content' field'  is returned escaped out:
<doc_content>&lt;?xml version="1.0"?&gt;
&lt;Page name="Direct Donation"&gt;  
&lt;Content type="include" handleError="false"&gt;header.jsp&lt;/Content&gt;
&lt;MainContent type="include" handleError="true"&gt;donation2.jsp&lt;/MainContent&gt;
&lt;Content type="include" handleError="false"&gt;footer.jsp&lt;/Content&gt;

Is there any way to have this content integrated into the document?


Best regards,

Please check that your question has not already been answered in the
FAQ before posting. <>

To unsubscribe, e-mail: <>
For additional commands, e-mail: <>

View raw message