I have a similar application - but the clob is an xml fragment ( meaning it doesn't have processing instruction tags ). So I can use get-xml instead of the get-ascii you use. Then I can access data in the xml fragment with the XSL stylesheet.
marty > -----Original Message----- > From: Russell Castagnaro [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 18, 2001 12:48 PM > To: [EMAIL PROTECTED] > Subject: [C2] Accessing CLOBs as Documents > > > 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]> > > --------------------------------------------------------------------- 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]>