The problem I have is:

I want to send a compete set of nodes (inkl. tags!) to the database.

--------- in my XSLT -----------
<xsl:variable name="all_kopf">
  <xsl:copy-of select="kopf"/>
</xsl:variable>

------- insert in DB -------
<sql:insert connection="$connection" table="vbi">
  <sql:column name="kopf" select="$all_kopf"/>
</sql:insert>

the value of the variable (all_kopf) is right, but if I insert it to the DB all the tags are lost!

for the better understanding:

------- my XML ------
<kopf>
  <tag1>foobar</tag1>
</kopf>

result of all_kopf: <kopf><tag1>foobar</tag1></kopf>
result in the DB: foobar
expected result in the DB: <kopf><tag1>foobar</tag1></kopf>

PS: I know that this is not the way to normaly store data, but I was asked to do so

Can anybody please help me

THX in advance

attention: noob on the way

This code looks as if you are using the Saxon SQL extension, is that right?

If you want to store serialized XML in the database, create a string holding the serialized data, by calling saxon:serialize(), and then store the resulting string.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Wow now I'm realy impressed! THX a lot Mr Kay!

Yes, I'm using the saxon parser. (for the first time and I really like it!)


attention: noob on the way