Hi, i've been to most cf forums and have yet you hear a reply about the following query ... here goes:
I am running cf 5 under win2k and sql server and am using a 3rd party COM+ API to access xml data. currently the site uses MSXML to query/output the xml. however, msxml would appear to be no good at putting the data back into the API. so i came across xml toolkit and it looks very promising indeed ... however i am still having difficulty putting data back. here is the data that is output: <Recordset> <Exchange> <OLOCode>MRCEN</OLOCode> <ExchangeAvailability>Available</ExchangeAvailability> <Customer>aaa</Customer> <EndDate>22-12-2002</EndDate> <Product>Access IP</Product> <ProductAvailability>Available</ProductAvailability> </Exchange> <Exchange> <OLOCode>MRCEN</OLOCode> <ExchangeAvailability>Available</ExchangeAvailability> <Customer>aaa</Customer> <EndDate>22-12-2002</EndDate> <Product>Access Data</Product> <ProductAvailability>Available</ProductAvailability> </Exchange><Exchange><OLOCode>MRCEN</OLOCode> <ExchangeAvailability>Available</ExchangeAvailability> <Customer>aaa</Customer> <EndDate>22-12-2002</EndDate> <Product>Access Voice</Product> <ProductAvailability>Available</ProductAvailability> </Exchange> </Recordset> this is then edited by forms .. and the resultant xml should be reinserted to the xml via the following API command SetExchangeData(BSTRExchangeUpdate, 1) where BSTRExchangeUpdate is the XML in the abovementioned format ... how would i collate the recordset into the string format to be manipulated by the API? thanks in advance. gary -----------------------+ cf-xml mailing list http://torchbox.com/xml/list.cfm
