[C2] Accessing CLOBs as Documents

[Russell Castagnaro]

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"?>

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

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

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

           <doc_content><esql:get-ascii column="doc_content"/></doc_content>
           <esql:get-columns/>
         </esql:row-results>
       </esql:results>
     </esql:execute-query>
   </esql:connection>

   </content>
  </page>
</xsp:page>


the 'doc_content' field'  is returned escaped out:
<doc_content>&lt;?xml version="1.0"?&gt;
&lt;Page name="Direct Donation"&gt;  
&lt;DefaultRoot&gt;/templates/seattletimes/&lt;/DefaultRoot&gt;  
&lt;Content-List&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;  
&lt;/Content-List&gt;  
&lt;Error&gt;error2.jsp&lt;/Error&gt;  
&lt;/Page&gt;</doc_content>



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


Thanks,
rrc

-- 
Best regards,
 Russell                          mailto:[EMAIL PROTECTED]


---------------------------------------------------------------------
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>