You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Robert Ellis Parrott <pa...@fas.harvard.edu> on 2002/11/05 05:34:52 UTC

Pulling XML data out of database

This is probably an easy one:

I want to pull a valid XML text out of a database using SQLTransformer if
possible.

Problem (1) everything is escaped away to &gt;, &lt;, and &#13;

Problem (2) the resulting text won't really be valid, since it would
include a second <?xml version="1.0"?>.



How do people do this?

rob

----------------------------
Robert E. Parrott
Department of Physics
351 Jefferson Laboratory
Harvard University
17 Oxford St.
Cambridge, Massachusetts 02138
(617)-495-2867
parrott@fas.harvard.edu
Robert.E.Parrott.96@alum.dartmouth.org (permanent)




---------------------------------------------------------------------
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:     <co...@xml.apache.org>
For additional commands, e-mail:   <co...@xml.apache.org>


Re: Pulling XML data out of database

Posted by "J.Pietschmann" <j3...@yahoo.de>.
Robert Ellis Parrott wrote:
> I want to pull a valid XML text out of a database using SQLTransformer if
> possible.
> 
> Problem (1) everything is escaped away to &gt;, &lt;, and &#13;
> 
> Problem (2) the resulting text won't really be valid, since it would
> include a second <?xml version="1.0"?>.
> 
> How do people do this?

You allocate an XML parser, feed it the string, and either
get a DOM document or feed the parser's SAX events directly
into the output stream. You'll probably need a custom
transformer or generator for this task.

J.Pietschmann



---------------------------------------------------------------------
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:     <co...@xml.apache.org>
For additional commands, e-mail:   <co...@xml.apache.org>