| Madani Benghia 2005-03-24, 5:50 pm |
| Hello,
I am trying to update the table OrderSample (setting the field "Status" to
4) using SQL updategram .After adding the update schema and the map ,my map
is generating the following xml file:
<ns0:UpdateOrderSampleRequest
xmlns:updg="urn:schemas-microsoft-com:xml-updategram"
xmlns:ns0="http://PanasonicBTSOrdersSystem.UpdateOrderSample">
<ns0:sync>
<ns0:before>
<ns0:OrderSample updg:id="1" OrderId="1"></ns0:OrderSample>
<ns0:OrderSample updg:id="2" OrderId="2"></ns0:OrderSample>
</ns0:before>
<ns0:after>
<ns0:OrderSample updg:id="1" Status="4"></ns0:OrderSample>
<ns0:OrderSample updg:id="2" Status="4"></ns0:OrderSample>
</ns0:after>
</ns0:sync>
</ns0:UpdateOrderSampleRequest>
Unforrtunately this did not update the database and generated errors.As you
know this is an SQLXML file,so i configured IIS for SQLXML support
(according to the documentation) and then called the xml file from IE.It did
not work until i changed the following values :
<ns0:sync> to <updg:sync>
<ns0:before> to <updg:before>
<ns0:after> to <updg:after>
After doing that i can run the xml file from IE and the update is done.My
question is : how do i edit the schema/the map so it to generates the "updg"
prefix for the tags "sync","before",and "after" instead of "ns0"?
Here is the file after the change :
<ns0:UpdateOrderSampleRequest
xmlns:updg="urn:schemas-microsoft-com:xml-updategram"
xmlns:ns0="http://PanasonicBTSOrdersSystem.UpdateOrderSample">
<updg:sync>
<updg:before>
<ns0:OrderSample OrderId="1" updg:id="1">
</ns0:OrderSample>
<ns0:OrderSample OrderId="2" updg:id="2">
</ns0:OrderSample>
</updg:before>
<updg:after>
<ns0:OrderSample updg:id="1" Status="4">
</ns0:OrderSample>
<ns0:OrderSample updg:id="2" Status="4">
</ns0:OrderSample>
</updg:after>
</updg:sync>
</ns0:UpdateOrderSampleRequest>
Thank you in advance.
Madani
|