Hi,
I have an XML-file like this:
<?xml version="1.0" encoding="UTF-8"?>
<DBInspector ReportName="Query Report" Date="15.01.2004">
<SQLStatement>select * from testdb2.person p, testdb2.adresse a where
p.persnr = a.persnr</SQLStatement>
<ColumnNames>
<Column>persnr</Column>
<Column>name</Column>
<Column>vorname</Column>
<Column>nr</Column>
...
</ColumnNames>
<ColumnEntries>
<Row>
<Entrie type="Integer">1</Entrie>
<Entrie type="Variable Character">Wehnert</Entrie>
<Entrie type="Variable Character">Lothar</Entrie>
<Entrie type="Variable Character">Yoyo</Entrie>
<Entrie type="Variable Character">Lothar</Entrie>
...
</Row>
<Row>
<Entrie type="Integer">2</Entrie>
<Entrie type="Variable Character">Egg</Entrie>
<Entrie type="Variable Character">Loth</Entrie>
<Entrie type="Variable Character">Was</Entrie>
<Entrie type="Variable Character">Ertz</Entrie>
...
</Row>
...
My aim is to create a table after e.g. every second column.
Something like this:
persnr name
----------------
1 Wehnert
2 Egg
vorname nr
----------------
Yoyo Lothar
Was Ertz
Unfortunately I cannot change the structure of the XML-file, therefore I
have no clue how to solve this problem.
How can I create a loop around <ColumnNames> and <ColumnEntries> ?
Anyone got an idea?
Thanks
Jonny
_________________________________________________________________
MSN Messenger - sehen, welche Freunde online sind!
http://www.msn.de/messenger Jetzt kostenlos downloaden und mitmachen!