icottee@bluefountain.com writes:
I have a table for chickens.... And another table for types....
Each chicken has a type associated with it. At the end of the day I want to display the chickens underneath the type it has ... start the screen up it would say
+ BIG + MEDIUM + SMALL
And the users can then expand to see the chickens available in each category.
+ BIG - Flossie - Wombat - Hank + MEDIUM - Debbie - Fruitbat - Harold + SMALL - Bob
I think, I have a solution for you, but it is a bit tricky and you must fill out the details. I am not sure, it will work. Let's show the picture. You have two Z SQL methods: one for the top level (i.e. type table) without parameters, one for the chicken level with parameter type. You have a DTML method "branches". It should determine the branches in the current context. It looks at the variable "tree-level" to determine whether it must call the type or the chicken Z SQL method. If you need to use the chicken Z SQL method, you are in a context that knows the current type. You call the method with something like: <dtml-return "chicken(type=type)"> You may need to adapt the names to your case. Good luck Dieter