Nate, I would like to see it ;)
On 9/28/06, David L. Penton <[EMAIL PROTECTED]> wrote:
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/
--
diabetic? http://www.diabetesforums.com
Albert Einstein - "It's not that I'm so smart, it's just that I stay
with problems longer."
_______________________________________________
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/
