Hierarchical listings

[Sam Churchill]

I have need to show a list of areas indented hierarchically on an ASP web
page like the following example.

The World
Europe
United Kingdom
England
Wales
Scotland
Northern Ireland
France
Germany
The Americas
North America
State 1
State 2
South America
Columbia
...



The data is held in a database table which has 3 fields (areaID, area,
subAreaOf). The data from the above example would be as follows.

areaID area subAreaOf
1 The World
2 Europe 1
3 United Kingdom 2
4 England 3
5 Scotland 3
6 Wales 3
......You get the idea...

Any idea how to generate the indented listings as economically as possible
on the queries.

Thanks,

Sam

 

[Manohar Kamath [MVP]]

Sam,

While I don't have the exact code, you might want to look at some recursive
code. Perhaps a code on threaded discussions should help you.

 

[Marc]

my tree code does exactly what your asking for:
http://www.braincast.nl/?deeplink=dhtml/asptree

click view and look at the 'simple' version, you can download
a zip file with all the samples...

http://www.braincast.nl/dhtml/asptree/files/tree.asp