Re: SQL Transformer Bug?

[Dev at weitling]

Hi dan,

I wonder it works at all.

You have to replace at least the "<" via the "&lt;" entity, perhaps the
">" via "&gt;", too. Otherwise the tags you mean as strings are
interpreted as tags, and only the XML text between is gathered from the
update query.

Bye,
Florian

> <sql:query name="nodeset">
> INSERT INTO mytable (nodeset)
> VALUES ('<root><record id="1"><name>John
> Smith</name><city>London<city></record></root>');
> </sql:query>
> </sql:execute-query>
>
> would insert: 1JohnSmithLondon into my database.
>
> If I plug this query into my sql editor, I correctly get:
> <root><record id="1"><name>John
> Smith</name><city>London<city></record></root>
> inserted into the database.
>
> What am I doing wrong?
>
> Thanks!
>
>
> ---------------------------------------------------------------------
> 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]