[Zope] How to stuff a tree from a SQL query?

Steen Suder sfs@sciatl.dk
Wed, 13 Oct 1999 09:59:50 +0000


As posted the other day, I'd like to create a (multilevel) tree from the
results of a SQL query.

With insightful input from Hannu, I've simplified my db design to
something more useful.
I have, among other fields, a node_id and a parent_id.
This should be sufficient to create a tree of "one way linked lists" as
I remember them from class.

Now my question is:
How do I stuff the results from the SQL query into the tree?

Stuffing files and folders into a tree is no problem.

-- 
Best regards / Mvh.,
Steen Suder
Linux Systems Administrator
Use "sfs @T sciatl DOD dk" for email