 | | | RDBMSResolver does not process results_packet XML | RDBMSResolver does not process results_packet XML 2004-03-16 - By Jason Cowley
Back
Has anyone been able to successfully update a DataSet using a RDBMSResolver?
I'm able to get the basic functionality to work: the server sends back a
results_packet that confirms the operation and also updates the fields of
the modified item with new data. For example, this works:
update packet xml:
<update_packet tableName="pages" nullValue="{_NULL_}"
transID="IID27614677232:Tue Mar 16 13:03:01 GMT-0800 (See http://GMT-0800.ora-code.com) 2004">
<update id="IID30274763005">
<field name="id" type="Integer" oldValue="2659" key="true"/>
<field name="itemNumber" type="Integer" oldValue="0" newValue="1"
key="false"/>
</update>
</update_packet>
results packet xml:
<results_packet transID="IID27614677232:Tue Mar 16 13:03:01 GMT-0800 (See http://GMT-0800.ora-code.com) 2004"
nullValue="{_NULL_}">
<operation id="IID30274763005" op="update">
<field name="href" curValue="http://somewhere.com"/>
</operation>
</results_packet>
However, the following does not work. In the example below I try to confirm
the operation in the results_packet and also update an additional item in
the DataSet.
update packet xml:
<update_packet tableName="pages" nullValue="{_NULL_}"
transID="IID16258873977:Tue Mar 16 14:22:13 GMT-0800 (See http://GMT-0800.ora-code.com) 2004">
<update id="IID71506630490">
<field name="id" type="Integer" oldValue="2202" key="true"/>
<field name="itemNumber" type="Integer" oldValue="0" newValue="1"
key="false"/>
</update>
</update_packet>
results packet xml:
<results_packet transID="IID16258873977:Tue Mar 16 14:22:13 GMT-0800 (See http://GMT-0800.ora-code.com) 2004"
nullValue="{_NULL_}">
<operation id="IID71506630490" op="update"/>
<update>
<field name="id" oldValue="2659" key="true"/>
<field name="itemNumber" newValue="0"/>
</update>
</results_packet>
When the results_packet is bound to the RDBMSResolver's updateResults
property, no fields in the DataSet are updated correctly. The only thing
that happens is that a few field values disappear from one of the other
items in the DataSet (one of the items in the DataSet that is not even being
updated).
Can anyone provide example XML for an update_packet and a corresponding
results_packet that correctly updates values in a DataSet?
Thanks in advance,
~j.
=-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
Supported by Fig Leaf Software
=-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
Be sure to check the archives and the wiki:
http://chattyfig.figleaf.com/
=-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
http://chattyfig.figleaf.com/cgi-bin/ezmlm-cgi?1:mss:107153
=-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
To unsubscribe send a blank e-mail to:
Normal Mode: flashcoders-unsubscribe@(protected)
Digest Mode: flashcoders-digest-unsubscrive@(protected)
|
|
|