Not sure if you received any hits on this, but I'm trying to do
something similar. I have the same sort of db structure as the
Sitepoint article, but I'm trying to build a select list. I would like
to show all rows, but append the parent "titles" on to the left of the
"title".
For this table:
1 Programming 0
2 Cooking 0
3 Microsoft 1
4 Visual Basic 3
5 Vegetarian 2
The select menu would look like this:
1 Programming
2 Cooking
3 Programming - Microsoft
4 Programming - Microsoft - Visual Basic
5 Cooking - Vegetarian
Any thoughts on how I could modify the Sitepoint algorithm to do
something like this?
Thanks,
Chris Dempsey
On May 19, 2004, at 7:29 AM, Tim Blair wrote:
> Afternoon,
>
> Has anyone written an example of modified preorder tree traversal
> [http://www.sitepoint.com/print/hierarchical-data-database] for MySQL
> in
> CF? I've done inserts and deletes (plus various selects) but I haven't
> sat down to work out updates (moving a node from one parent to another)
> yet, so I thought I'd check if anyone's got an example before I go
> ahead...
>
> Cheers,
>
> Tim.
--
***********************
Chris Dempsey
Director, Information Services
UCSB Graduate Division
Quis custodiet ipsos custodies
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
