On Sep 5, 5:37=A0pm, "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=3D"10248">
> > =A0 =A0 <OrderItem ProductID=3D"11">
> > =A0 =A0 =A0 =A0 =A0<QuantityIncrease>2</QuantityIncrease>
> > =A0 =A0 </OrderItem>
> > </Order>
>
> > Here is a bit i did:
>
> > <?xmlversion=3D"1.0" encoding=3D"UTF-8">
> > <xsl:stylesheet version=3D"1.0" xmlns:xsl=3D"http://www.w3.org/1999/XSL=
/
> >Transform">
> > =A0 =A0 <xsl:input href =3D"WriteXMLToDBTest_Order.xml"/>
> > =A0 =A0 <xsl:output method=3D"text" encoding=3D"UTF-8"/>
>
> > =A0 =A0 <xsl:template match=3D"/">
> > =A0 =A0 =A0 =A0 =A0<xsl:apply-templates select=3D"Order"/>
> > =A0 =A0 </xsl:template>
>
> > =A0 =A0 <xsl:tempalte match=3D"Order">
> > =A0 =A0 =A0 =A0 =A0<xsl:text>update</xsl:text>
> > =A0 =A0 =A0 =A0 =A0<xsl:value-of select=3D"Order Details"/>
> > =A0 =A0 </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 mea=
nxsl: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 =3D 12 where orderid =3D 10248 and
productid =3D 11