I use MySQL and it does have a replace function.
But, as I want to be independant from the target platform, I prefer  to 
do it in the XSL stylesheet so, when I do FO transformation, I don't 
have to change my XSP.
Thanks again for your solution
Sébastien

>What about doing the replacements in your SELECT statement to create
>well-formed XML, then using the <esql:get-xml ...> to retrieve it?  In
>Oracle, it would look like:
>
>SELECT '<mytext>' || REPLACE(mytextfield, CHR(10), '<BR/>') || '</mytext>
>FROM ....
>
>I would guess most RDBMS have a similar capability.
>
>-Christopher
>


---------------------------------------------------------------------
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]>

Reply via email to