Something like:

<xsl:stylesheet version="1.0" 
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text" encoding="UTF-8"/>
<xsl:template match="/">
<xsl:apply-templates select="Order"/>
</xsl:template>
<xsl:template match="Order">
<xsl:text>update order_details set quantity = </xsl:text>
<xsl:value-of select="OrderItem/QuantityIncrease"/>
<xsl:text> where orderid = </xsl:text>
<xsl:value-of select="@ID"/>
<xsl:text> and productid = </xsl:text>
<xsl:value-of select="OrderItem/@ProductID"/>
</xsl:template>
</xsl:stylesheet>

depending on how dynamic the actual names , like ProductID, are.

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

<andie.du168@g...> wrote in message 
news:1f3d63e5-12cf-4a6b-9920-70cb1d40061d@p......
On Sep 5, 5:37 pm, "Joe Fawcett" <joefawc...@newsgroup.nospam> wrote:
> <andie.du...@gmail.com> wrote in message
>
> news:e2bfc74a-4dc8-4ea2-b40a-47f860265457@b......
>
>
>
> > i have thisxmlhere, and now i would like to usexsltotransform
> > into an Updatesqlstatement like this:
> > Here is theXMLdocument:
>
> > <Order ID="10248">
> > <OrderItem ProductID="11">
> > <QuantityIncrease>2</QuantityIncrease>
> > </OrderItem>
> > </Order>
>
> > Here is a bit i did:
>
> > <?xmlversion="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 thexsl:input element? I haven't seen that one before, did you 
> meanxsl:include orxsl:import?
> Can you show an example of whatSQLstatement should be produced by theXML
> you gave?
>
> --
>
> Joe Fawcett (MVP -XML)http://joe.fawcett.name- Hide quoted text -
>
> - Show quoted text -

Hi Joe,

Thanks very much for your reply.

what i need in here is:
I want the xsl read the xml, so i think it is xsl:import, which is the
one that i provided at the very beginning, and i want to transform to
this sql statement:
update order_details set quantity = 12 where orderid = 10248 and
productid = 11