xml xdr transalation

[Guest]

how would you map each of these elements to their repsective columns in a sql table using an xdr schema, without changing the layout of the xml?


<root>
<fields>
<field name="FirstName">Mike</field>
<field name="LastName">Smith</field>
<field name="Address">123 sesame st</field>
</fields>
</root>

[george]

Sorry,

I do not understand your question. Also Oxygen does not have support for XDR schemas.

I do not know if this helps but you can use an XSLT stylesheet to convert your document to an SQL statement that will insert that data into a database assuming you know the table name or pass it as parameter to the XSLT stylesheet.

Best Regards,
George