How to add a sub table to a dataset table and access it

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
Hi, im currently with data coming from xml. my application gather sql data through a php server interface.. the php return data in xml format..
the xml is formatted this way.

<div style="color:Black;background-color:White; <pre>
<span style="color:Blue; <<span style="color:#A31515; Clients<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Client<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; ClientDataA<span style="color:Blue; >Data a<span style="color:Blue; </<span style="color:#A31515; ClientDataA<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; ClientDataB<span style="color:Blue; >Data b<span style="color:Blue; </<span style="color:#A31515; ClientDataB<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; ClientDataC<span style="color:Blue; >Data c<span style="color:Blue; </<span style="color:#A31515; ClientDataC<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; ClientDataD<span style="color:Blue; >Data d<span style="color:Blue; </<span style="color:#A31515; ClientDataD<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Products<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Product<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Name<span style="color:Blue; >name<span style="color:Blue; </<span style="color:#A31515; Name<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Id<span style="color:Blue; >0001<span style="color:Blue; </<span style="color:#A31515; Id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Description<span style="color:Blue; >bla bla bla<span style="color:Blue; </<span style="color:#A31515; Description<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; Product<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Product<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Name<span style="color:Blue; >name<span style="color:Blue; </<span style="color:#A31515; Name<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Id<span style="color:Blue; >0002<span style="color:Blue; </<span style="color:#A31515; Id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Description<span style="color:Blue; >bla bla bla<span style="color:Blue; </<span style="color:#A31515; Description<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; Product<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Product<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Name<span style="color:Blue; >name<span style="color:Blue; </<span style="color:#A31515; Name<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Id<span style="color:Blue; >0003<span style="color:Blue; </<span style="color:#A31515; Id<span style="color:Blue; >
<span style="color:Blue; <<span style="color:#A31515; Description<span style="color:Blue; >bla bla bla<span style="color:Blue; </<span style="color:#A31515; Description<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; Product<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; Products<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; Client<span style="color:Blue; >
<span style="color:Blue; </<span style="color:#A31515; Clients<span style="color:Blue; >
[/code]

<br/>
then the xml is read through the dataset.readxml() interface..
How can i access my Products sub table.. the data dont seems to be grabbed by the readxml method.. or im just not looking in the right place.

View the full article
 
Back
Top