i use esql for that
look at esql:get-xml
-- stavros
a code snip:
<esql:connection>
<esql:pool>hotpoints</esql:pool>
<esql:execute-query>
<esql:query>SELECT * FROM tblTextBlocks WHERE
id_TextBlocks=<xsp-request:get-parameter name="id"/>
</esql:query>
<esql:results>
<esql:row-results>
<block>
<id_TextBlocks><esql:get-string column="id_TextBlocks"
root="id_TextBlocks"/></id_TextBlocks>
<textBlock_Title><esql:get-string column="textBlock_Title"
root="textBlock_Title"/></textBlock_Title>
<esql:get-xml column="textBlock_Description" root="textBlock_Description"/>
</block>
</esql:row-results>
</esql:results>
<esql:no-results>
no record was found
</esql:no-results>
</esql:execute-query>
</esql:connection>
On Thu, 12 Aug 2004, Stephan Coboos wrote:
> Hello,
>
> is there a generator (or other component) available, which reads a
> textfield (contains wellformed xml) form a db (relational, oracle) and
> includes the text as xml into the pipeline?
>
> Thank you.
>
> Regards
> Stephan
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
