Re: Preorder tree traversal algorithm
Chris, I think my "tree view of entity-relationship and data view" would be closer to what you have in mind, but I don't intend to make it public for now, care to take a peak at it? My email address, donli at hegelsoftware dott com. Thanks. Don >Don, > >Thanks, I'm not exactly sure how I could use your site for my app. The >Graduate Division uses MSSQL 2K. > >Thanks, > >Chris > >On Mon, 24 May 2004, Chunshen Li wrote: > >> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Preorder tree traversal algorithm
Don, Thanks, I'm not exactly sure how I could use your site for my app. The Graduate Division uses MSSQL 2K. Thanks, Chris On Mon, 24 May 2004, Chunshen Li wrote: > Chris, > > I've implemented an entiy-relationship schema into a generic search application, sample deployment url, > http://68.32.63.205/snap/ddSearch.cfm > > A tree view of entity-relationship is at beta stage. > > btw, what DBMS are you folks are using at UCSB? > > Regards, > > Don > > >Tim, > > > >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: > > > > > > > >-- > > > > > >*** > >Chris Dempsey > >Director, Information Services > >UCSB Graduate Division > >Quis custodiet ipsos custodies > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Preorder tree traversal algorithm
Chris, I've implemented an entiy-relationship schema into a generic search application, sample deployment url, http://68.32.63.205/snap/ddSearch.cfm A tree view of entity-relationship is at beta stage. btw, what DBMS are you folks are using at UCSB? Regards, Don >Tim, > >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: > > > >-- > > >*** >Chris Dempsey >Director, Information Services >UCSB Graduate Division >Quis custodiet ipsos custodies [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Preorder tree traversal algorithm
Tim, 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]
Preorder tree traversal algorithm
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. -- --- Maze Solver - http://tech.badpen.com/cfcontest/ --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]