Re: Web dynamic data tree software to show relationships .... by Evertjan
Evertjan
Thu Apr 03 14:42:58 CDT 2008
bcap wrote on 03 apr 2008 in microsoft.public.inetserver.asp.general:
> I am looking for a software that can generate a tree of data. For
> example, I am trying to track real estate relationships like a lessor,
> tenant, general contractor, and subcontractors. I would like a visual
> representation of this relationship based on the values in my database
> showing the hierarchy much like a site map or family tree.
>
> Can anyone recommend how I could do this or suggest a software?
>
When you have a database with records, having n pointers to other such
records in it's fields, it really is a just a simple reentrant subroutine,
[except for the graphical part].
ASP-vbscript pseudocode:
depth = -1
function getTheRecord(x)
increment depth
show the content of this record, using the depth for graphic position
getTheRecord(pointer-1)
getTheRecord(pointer-2)
.....
getTheRecord(pointer-n)
decrement depth
end function
getTheRecord starting-record-pointer-here
--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)