[Zope] dtml-tree stuff

2000-11-30 Thread Mike Kelland



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
[EMAIL PROTECTED] 



Re: [Zope] dtml-tree stuff

2000-11-30 Thread Stuart Foster

I have a similar need and have found the How-To's cryptic also. I too get 
company1 over and over.

Original Message dated 11/30/00, 3:12:00 PM
Author: Mike Kelland [EMAIL PROTECTED]
Re: [Zope] dtml-tree stuff:


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
[EMAIL PROTECTED] 

___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )