EDN Admin
Well-known member
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
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