🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.jbuilder.java.swing
Article #12360

building tree from sql

#12360
From: Martin P. Misseyer
Date: Thu, 14 Jan 1999 00:00
28 lines
1081 bytes
Hello,

This is probably a novice problem that's bothering me.

Say i have a ODBC database table looking like this:

key   description
1000 division A
1100 major group a
1110 industry group 1
1111 activity 1
1112 activity 2
1113...
1114...
1120 industry group 2
etc.

the key represents an impliciy hierachy.

Does anybody know how to build a tree on the fly?
Can you give me sample code? (put the data in your own table and mail me
the
ASCII export of the table).

Thanx in advance,

Martin P. Misseyer
mmisseyer@econ.vu.nl
Technical Details
Message-ID: <369DFDED.1F0D0E7C@econ.vu.nl>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 111d45,938cdee996659cbb,start
X-Google-Attributes: gid111d45,public
From: "Martin P. Misseyer" <mmisseyer@econ.vu.nl>
Subject: building tree from sql
Date: 1999/01/14
Message-ID: <369DFDED.1F0D0E7C@econ.vu.nl>
X-Deja-AN: 432546885
Content-Transfer-Encoding: 7bit
X-Accept-Language: nl
Content-Type: text/plain; charset=us-ascii
Organization: Vrije Universiteit / Free Universiteit Amsterdam
Mime-Version: 1.0
Newsgroups: borland.public.jbuilder.java.swing