Return-Path: Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org Received: (qmail 10102 invoked by uid 500); 18 Oct 2001 17:15:47 -0000 Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Reply-To: cocoon-users@xml.apache.org Delivered-To: mailing list cocoon-users@xml.apache.org Received: (qmail 10081 invoked from network); 18 Oct 2001 17:15:47 -0000 X-MimeOLE: Produced By Microsoft Exchange V6.0.4712.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: RE: [C2] Accessing CLOBs as Documents Date: Thu, 18 Oct 2001 13:13:50 -0400 Message-ID: <937B9574F4A2A344812CB180F5B5D25EB5CEB8@corpmail.eduprise.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [C2] Accessing CLOBs as Documents Thread-Index: AcFX9zTMP3UELrfdSJuW2KeBL4O7JgAAVTGg From: "Marty McClelland" To: X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N 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:russell@castagnaro.com] > Sent: Thursday, October 18, 2001 12:48 PM > To: cocoon-users@xml.apache.org > Subject: [C2] Accessing CLOBs as Documents >=20 >=20 > Hello cocoon-users, >=20 > I've got a problem. >=20 > 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 >=20 > currently I'm using xml like this: >=20 > >=20 > language=3D"java" > xmlns:xsp=3D"http://apache.org/xsp" > xmlns:esql=3D"http://apache.org/cocoon/SQL/v2" > > >=20 > > A Database XML DOC Page > >=20 > > fun > > Select * from XML_DOC where doc_id in=20 > (select max(doc_id) from xml_doc) > =20 > > >=20 > column=3D"doc_content"/> > > > > > >=20 > > > >=20 >=20 > the 'doc_content' field' is returned escaped out: > <?xml version=3D"1.0"?> > <Page name=3D"Direct Donation"> =20 > <DefaultRoot>/templates/seattletimes/</DefaultRoot> =20 > <Content-List> =20 > <Content type=3D"include"=20 > handleError=3D"false">header.jsp</Content> =20 > <MainContent type=3D"include"=20 > handleError=3D"true">donation2.jsp</MainContent> =20 > <Content type=3D"include"=20 > handleError=3D"false">footer.jsp</Content> =20 > </Content-List> =20 > <Error>error2.jsp</Error> =20 > </Page> >=20 >=20 >=20 > Is there any way to have this content integrated into the document? >=20 >=20 > Thanks, > rrc >=20 > --=20 > Best regards, > Russell mailto:russell@castagnaro.com >=20 >=20 > --------------------------------------------------------------------- > Please check that your question has not already been answered in the > FAQ before posting. >=20 > To unsubscribe, e-mail: > For additional commands, e-mail: >=20 >=20 --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. To unsubscribe, e-mail: For additional commands, e-mail: