I'm new to the list but I guess it works like most other lists :) a friend and I, well mostly the friend, worked out a system for this that sort of works, but it's really weird and isn't working properly if you do anything but serialize it to xml at this point, if you try to transform it, or aggregate it cocoon spits out invalid xml in the form of <> and </> tags :)
surely there has to be a good way to do this? other than Blobsource [1] which is slightly limited, and the way I'm currently working on that involves creating SAXParsers and whatnot. /patrik [1] http://www.mail-archive.com/cocoon-dev@xml.apache.org/msg12945.html Pavel Natov wrote: > hi there > > I'm still not sure about the problem that I have but here is the question: > I retrieve some data from Oracle database using ESQL logicsheet in a > XSP file. > > <esql:results> > > <esql:row-results> > > <title><esql:get-string column="title"/></title> > > <subtitle><esql:get-string column="subtitle"/></subtitle> > > <text><esql:get-string column="content"/></text> > > <encoding><esql:get-ascii column="encoding"/></encoding> > > </esql:row-results> > > </esql:results> > > > > The data retreived between <text> tags is XML alike > (<doc><bold>blabla</bold></doc>). My purpose is to transform this data > with XSLT and to produce html. When I use my XSLT to transform data from > file(with custom xml data) there is no problem. The problem is when in > my pipeline in the sitemap.xmap when I use the same XSLT it does not > match the tags retrieved from database because it escapes them with > <>.Even when I make second transformation using > > <xsl:value-of select="." disable-output-escaping="yes"/> > > just to transform the text between <text></text> in xml it does not > work. I produce this which would be ok if I save it to a file : > > <content> > <title> > some title > </title> > <subtitle> > <bold>Some subtitle</bold> > </subtitle> > <text> > <doc> > <paragraphleft> > First paragraph > <italic>This is italic text</italic> > </paragraphleft> > <paragraphcenter> > Second paragraph <bold>This is bold text</bold> > </paragraphcenter> > </doc> > </text> > </content> > But when I output it to a third transformation to make the actual HTML > transformation it matches only tags defined in the first xsp (with esql > tags). The tags between <text> are escaped with <> again. > > Anyway may be my method is not working. HOw to retrieve XML data from > database and not escape "<" ,">" > > I suppose that I'm not clear enough with my question but I could > revision it. > > > > > Best regards/ > > ...................................................... > Pavel Natov > Systems Developer > BIANOR > 5 Stratsin Str. > 1407 Sofia, Bulgaria > Mobile: (+359 87) 658 049 > Switchboard: (+359 2) 962 4564, (+359 2) 962 4574 > Fax: (+359 2) 962 4416 > mailto:[EMAIL PROTECTED] > http://www.bianor.com > ...................................................... --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
