cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan Hertz <>
Subject SQL Transformer Bug?
Date Sat, 18 Nov 2006 16:09:30 GMT
I'm hoping someone can help me troubleshoot why I can't insert an xml 
nodeset into my database using the SQL Transformer. All I end up with is 
the text() values concatenated together -- no elements or attribute 
nodes. For example:

<sql:execute-query xmlns:sql="">
<sql:query name="nodeset">
INSERT INTO mytable (nodeset)
VALUES ('<root><record id="1"><name>John 

would insert: 1JohnSmithLondon into my database.

If I plug this query into my sql editor, I correctly get:
<root><record id="1"><name>John 
inserted into the database.

What am I doing wrong?


View raw message