New topic: MySQL and Linked Lists
<http://forums.realsoftware.com/viewtopic.php?t=46045> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message neonash7777 Post subject: MySQL and Linked ListsPosted: Mon Nov 26, 2012 12:32 pm Joined: Mon Nov 29, 2010 7:01 pm Posts: 309 Let's say I have a table called activity and each activity has a field called parentActivity that points to the id of a different activity. Is there a way to query an entire linked list given a single activity id? Essentially get the activity's parent activity, and then that activity's parent activity etc... Until either it either reaches an ID it has already encountered (which should never happen but we need this to stop infinite loops) Or it reaches an activity without a parentId. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
