Recursive calls to a custom tag. That's the way to do it.
Each time, changing the parent ID.
-----Original Message-----
From: J. Steven Tripp [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 14, 2001 10:01 PM
To: Fusebox
Subject: Nested trees, what's going on?
I have read, re-read and read again the section in the fusebox book on
Nested trees. I get the database side of things, but the book doesn't
explain the SQL side of things very well. It shows a one table example for
the database and then goes on to show a two table example for the SQL.
I am trying to build a threaded discussion. Messages could go quite deep
in the parent/child relationship and there are some complex joins down the
road, but bringing it down to it's most basic level, let's say we have a
table that has only 3 fields:
PostID <--- Primary Key
ParentID
MessageText
What would the SQL statement look like. I have tried many variations on
the book, but nothing.
Suggesstions? Comments? Questions? Jokes?
-Steve
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
