Question on loops

Play the video

Subject: Question on loops
From: "Jonny Pony" <jonnypony666@xxxxxxxxxxx>
Date: Mon, 22 Mar 2004 17:31:40 +0000

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!

Current Thread
Question on loops Jonny Pony - Mon, 22 Mar 2004 12:32:20 -0500 (EST) <= Michael Kay - Mon, 22 Mar 2004 14:00:23 -0500 (EST) M. David Peterson - Mon, 22 Mar 2004 19:21:35 -0500 (EST) <Possible follow-ups> Jarno.Elovirta - Tue, 23 Mar 2004 18:10:57 -0500 (EST)

<- Previous	Index	Next ->
RE: "Group by" question, Jarno.Elovirta	Thread	RE: Question on loops, Michael Kay
Re: Newbie - trying to extrac, Wendell Piez	Date	Re: "Group by" question, Raffaele Sena
	Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >