From: dragoncity@...
Date: 2005-02-28T15:19:58+09:00
Subject: Ruby & Cache' Db with SOAP

I am trying to access a Cache DB using SOAP, the primative data types,
integer, string , etcare sucessfully returned, however when I attempt
to return a SET of db records Ruby just 'forgets' about them !

Any help appreciated.


Below is the XML 'script' returned by Cache, note the few entries thus:


	<SQL diffgr:id="SQL1" msdata:rowOrder="0">
<auctionID>234</auctionID>
<auctionName>Spare Parts</auctionName>
</SQL>


which are the desired test data I requested from Cache.

================================================================
-
	<SOAP-ENV:Envelope>
-
	<SOAP-ENV:Body>
-
	<listHeaderResponse>
-
	<listHeaderResult>
-
	<s:schema id="UnsortedData">
-
	<s:element name="UnsortedData" msdata:IsDataSet="true">
-
	<s:complexType>
-
	<s:choice maxOccurs="unbounded">
-
	<s:element name="SQL">
-
	<s:complexType>
-
	<s:sequence>
<s:element name="auctionID" type="s:long" minOccurs="0"/>
<s:element name="auctionName" type="s:string" minOccurs="0"/>
</s:sequence>
</s:complexType>
</s:element>
</s:choice>
</s:complexType>
</s:element>
</s:schema>
-
	<diffgr:diffgram>
-
	<UnsortedData>
-
	<SQL diffgr:id="SQL1" msdata:rowOrder="0">
<auctionID>234</auctionID>
<auctionName>Spare Parts</auctionName>
</SQL>
-
	<SQL diffgr:id="SQL2" msdata:rowOrder="1">
<auctionID>244</auctionID>
<auctionName>Spare Computer Parts</auctionName>
</SQL>
-
	<SQL diffgr:id="SQL3" msdata:rowOrder="2">
<auctionID>344</auctionID>
<auctionName>Spare Computer Printers</auctionName>
</SQL>
-
	<SQL diffgr:id="SQL4" msdata:rowOrder="3">
<auctionID>144</auctionID>
<auctionName>Spare Computer Screens</auctionName>
</SQL>
</UnsortedData>
</diffgr:diffgram>
</listHeaderResult>
</listHeaderResponse>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>