Celko Nested Trees. That's a ticket. Not the only one though...
There are several recursion techniques that do not require exhausting what stack space may be available. SQL Server 2005 now has
recursive CTEs (common table expressions) that provide for a roughly set based approach to solving this type of problem. DB2 v8 has
some interesting constructs similar to this as well.
&_david++;
miguel olivarez wrote:
The difficutly is in CF. SQL is not good at looping
and to format the recordset the way Joe wants it would
require looping over it.
--- Skipper Pickle
<[EMAIL PROTECTED]> wrote:
Daniel Eben Elmore wrote:
the solution requires recursion, a concept that is
rarely discussed in the CF community.
i wonder why that is. i've run across the problem
Joe describes in real
life before more than once. In my case, i was
trying to build a library of
resources, and i wanted to able to divide a topic
into subtopics
indefinitely.
Surely others run into this as well. Is the
difficulty in CF or is it in
SQL?
---
Skipper Pickle
972.978.5807
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
