ResolutionsNET
IS-IT--Management
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
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