I think I may not have asked a specific enough
question last time round. I'll try it again. I've been looking
through the How-To's and the documentation and the dtml-tree stuff that I have
found seems exceedingly cryptic. The closest that I've come to a solution
is the following code:
<dtml-in
"getAllClientNames(REQUEST)">
<dtml-tree id=clientID
branches_expr="getClientsForProjects(get_clientID=clientID)"
>
<dtml-var
company_name>
</dtml-tree>
</dtml-in>
where
getAllClientNames looks like:
select company_name,clientID from
client;
and getClientsForProjects looks like:
select company_name, clientID from client where
deleted = 0 and clientID = <dtml-sqlvar get_clientID
type=int>;
This gives me a tree structure which, when I expand
company1 gives me company1 again and again
(ie
Company1
Company1
Company1
Company1
etc as deep as I care to go
Company2
Company2
etc
Company3
Company4
What I'm trying to do is list my company name as
the tree branch and have the sub headings of each branch be my projects for that
company. Can anyone help?
Thanks very much
Mike Kelland