>Archive Index
>microsoft.public.xsl Archive Home
>Recent entries

[Thread Prev]
>Thread Next - Re: transform XML to SQL by XSL

transform XML to SQL by XSL

From: andie.du168@-----.---
To: NULL
Date: 9/4/2008 7:39:00 PM

i have this xml here, and now i would like to use xsl to transform
into an Update sql statement like this:
Here is the XML document:

<Order ID="10248">
     <OrderItem ProductID="11">
          <QuantityIncrease>2</QuantityIncrease>
     </OrderItem>
</Order>

Here is a bit i did:

<?xml version="1.0" encoding="UTF-8">
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/
Transform">
     <xsl:input href ="WriteXMLToDBTest_Order.xml"/>
     <xsl:output method="text" encoding="UTF-8"/>

     <xsl:template match="/">
          <xsl:apply-templates select="Order"/>
     </xsl:template>

     <xsl:tempalte match="Order">
          <xsl:text>update</xsl:text>
          <xsl:value-of select="Order Details"/>
     </xsl:tempalte>
</xsl:stylesheet>

as i am still new in this field, can someone guide me through?

Many thanks

[Thread Prev]
>Thread Next - Re: transform XML to SQL by XSL

>Archive Index
>microsoft.public.xsl Archive Home
>Recent entries

Altova Mailing List Archives

transform XML to SQL by XSL