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><?xml version="1.0"?> <Page name="Direct Donation"> <DefaultRoot>/templates/seattletimes/</DefaultRoot> <Content-List> <Content type="include" handleError="false">header.jsp</Content> <MainContent type="include" handleError="true">donation2.jsp</MainContent> <Content type="include" handleError="false">footer.jsp</Content> </Content-List> <Error>error2.jsp</Error> </Page></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]>