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