Yes, this can be done quite efficiently with cursors in SQL - do not fall
into the trap of doing it through recursion in SQL. SQL only allows 16
levels of depth with recursive SP's and its highly inefficient.
I can post an example if anyone is interested. It takes a minute for the
solution to clikc, but once it does it makes sense. =)
-Nate
----- Original Message -----
From: "miguel olivarez" <[EMAIL PROTECTED]>
To: "Dallas/Fort Worth ColdFusion User Group Mailing List"
<[email protected]>
Sent: Thursday, September 28, 2006 2:24 PM
Subject: RE: [DFW CFUG] Another Brain Teaser
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/
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
_______________________________________________
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/
_______________________________________________
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/
