<andie.du168@g...> wrote in message 
news:e2bfc74a-4dc8-4ea2-b40a-47f860265457@b......
> 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
What is the xsl:input element? I haven't seen that one before, did you mean 
xsl:include or xsl:import?
Can you show an example of what SQL statement should be produced by the XML 
you gave?

-- 

Joe Fawcett (MVP - XML)
http://joe.fawcett.name