Deciphering the Z:Row Node

admin

Administrator
Staff member
Hi -I am starting to work with XML and I am wondering about how to search throughthe xml stream that ADO 2.6 can be made to return from a query.When I print out the xml data stream that is returned to me from the databaseI get the following:<rs:data><z:row ProjectID='2001' Description='nCompass Internal Project'AccountManager='Blah' CustomerManager='Blah' Comments='Blah'/><z:row ProjectID='2002' Description='Market Finance Internal Project'AccountManager='blah' CustomerManager='blah' Comments='blah'/><z:row ProjectID='2003' Description='Employee Personal Time'AccountManager='blah' CustomerManager='blah' Comments='blah'/></rs:data>I can find the and return the rs:data node. But, It seems that I am facedwith having to loop through all of the z:row nodes to find the record thatI am looking for. But, with large data sets, a loop would quickly becomecounter productive.Is there another way?Larry
 
Back
Top