[Zope] Newbie: dtml-tree

[Ashley Lloyd]

I am hoping to use dtml-tree to display the results of SQL statements. I 
have looked around, and there seems to be quite a bit of information on 
dtml-tree, but much of it is out of date, and most only uses it to list 
folder contents.

The data structure is as follows:

The root node would be a result of an SQL which can only yield one result - 
say, warehouseNameSQL returns Warehouse name given the Warehouse ID.

Then, an SQL statement (say productsInWareSQL) returns all products in that 
warehouse, sorted by category. The next level below root would be product 
categories, the third product names/ids. So, if the category (say categoryB) 
of product3 is the same as product2, then this is just listed as a sibling 
of product2 (both children of categoryB). If product3 is in categoryC, 
however, categoryC is listed as a sibling of categoryB, and product3 as the 
first child.

I know I didn't explain that very well, so more graphically I want the tree 
structure to look something like this:

Warehouse_Alpha
- CategoryA
     Product1
     Product2
- CategoryB
     Product3
- CategoryC
     Product4
     Product5
     Product6
     Product7
     Product8
     Product9
- CategoryD
     Product10

Can anyone tell me if this is possible with dtml-tree, and if so give me 
some ideas as to how.

I've tried implementing it, and I can get a list of the Categories, but 
instead of listing each category once, it lists each category once for every 
product in that category. I also can't expand the tree at all, as when it 
attempts to expand it seems to lose the initial Warehouse ID, and gives a 
NameError (global name 'warehouseID' is not defined).
(I've tried setting urlparam to be "'warehouseID='+warehouseID", but it 
seems to want only a static string, not one that is made up depending on the 
value passed to the document.)

There is no problem with the sql, as I have implemented it without using 
dtml-tree, just indenting levels further using columns. We would, however, 
much prefer to use a proper tree structure.

TIA

Kind regards

Ashley

_________________________________________________________________
Chat online in real time with MSN Messenger http://messenger.msn.co.uk