Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hierarchical Recordset to XML

Status
Not open for further replies.

ResolutionsNET

IS-IT--Management
Jul 31, 2000
70
GB
Hi,

can someone help me,

I have a database table that look simular to
id, title, data, parent_id
1, Home, stuff, 0
2, Bedroom, stuff, 1
3, Living Room, stuff, 1
4, TV, stuff, 3

and so on and I would like to transform this into XML with ADO call.

So that it'll reflect it's structure, i.e.
<house>
<home>
<Bedroom></Bedroom>
<Living Room>
<TV></TV>
</Living Room>
</home>
</house>

Can any one point me in the correct direction.

Cheers




 
Winter,

Okay you have the basic layout of the xml file listed above..with some additions maybe to come later.

name it house.xml

Then get a reference on XSD(xml schemas). Then create the data layout that you wish.
Then to make it in to HTML use XSLT via XSD via XML pages....Yes it is a complex long progress. But then you can have it the way that you want.

Hope this helps a lil.
Good reference books that I use are from Wrox Press( -- the book for you would be XML Databases, XML Schemas and XSL.

Aaron
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top