Re: Pulling XML data out of database
Well you could probably write another transformer (to be placed after the SQLTransformer in the pipeline) that would change the escaped charactors into ... It could also look for the second ?xml version=1.0? and not pass it through. That's kind of brutal coding IMO. Another option may be XSP with the util stylesheet. You'd have to look into the email lists for examples. The one issue with it also is that everything must be on the same line so you don't get line feed charactor return stuff. Beyond that it works nice. your call. I use the XSP/util tags myself for including XML fragments. As well as XSP to access the database. So you may also want to think if you want to do the database actions vs XSP ESQL first and then write a transformer vs using XSP UTIL tags to include the XML into your outputted XML. Some like do db actions and others use XSP... but that may dictate your solution for including XML. MD - 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]
Re: Pulling XML data out of database
Yep. I gave up a SQLTransformer for this, and just went with XSP ESQL. thanx, rob On Tue, 5 Nov 2002 [EMAIL PROTECTED] wrote: Well you could probably write another transformer (to be placed after the SQLTransformer in the pipeline) that would change the escaped charactors into ... It could also look for the second ?xml version=1.0? and not pass it through. That's kind of brutal coding IMO. Another option may be XSP with the util stylesheet. You'd have to look into the email lists for examples. The one issue with it also is that everything must be on the same line so you don't get line feed charactor return stuff. Beyond that it works nice. your call. I use the XSP/util tags myself for including XML fragments. As well as XSP to access the database. So you may also want to think if you want to do the database actions vs XSP ESQL first and then write a transformer vs using XSP UTIL tags to include the XML into your outputted XML. Some like do db actions and others use XSP... but that may dictate your solution for including XML. MD - 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] - 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]
Re: Pulling XML data out of database
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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 [EMAIL PROTECTED] [EMAIL PROTECTED] (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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]