Recursion to retrieve blog thread - help please

2008-11-05 Thread Christophe Maso
I feel I should know how to do this, but I haven't really had to write a function like this yet. We have a blog site where, currently, users can post entries to their own respective blog, and replies can be made to that entry. Entries are kept in an entries table, and replies are kept in a

Re: Recursion to retrieve blog thread - help please

2008-11-05 Thread Jason Fisher
Original call would look something like this, where entryID is all you need to start with: cfset myReplyTreeQry = getChildren(url.entryID, request.datasource) This would create a query result called myReplyTreeQry with the following columns: entryID replyID (of each reply)

Re: Recursion to retrieve blog thread - help please

2008-11-05 Thread Christophe Maso
Thank you very much - this works beautifully! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: