| Author |
 Topic  |
|
|
webguru22
Starting Member
USA
11 Posts |
 Posted - 12/06/2000 : 17:50:45
|
Hi SQL gurus,
Here's a twist on the old "threaded message board query" question:
I need to come up with a data modle that will let me have elements in an "outline" like this:
<pre>1.0 Top-level element
1.1 Second Level element
1.2 Second Level element
1.2.1 Third Level element
1.2.2 Third Level element
1.3 Second Level element
2.0 Top level element
2.1 Second Level element
2.2 Second Level element
2.3 Second Level element
2.3.1 Third Level Element
2.3.2 Third Level Element
2.3.2.1 Fourth Level element
2.3.3 Third Level Element
3.0 Top level element...
</pre>
And so on. The catch is, unlike a forum , there is no way to sort the elements by date, and to make it even more fun, I have to be able to select an element, and move it up or down in the heirarchy. So if I move element 2.3 up, it becomes 2.2, and 2.3.1 becomes 2.2.1, etc. And of course 2.2 becomes 2.3, swapping the spots in the heirarchy.
I'm not sure if I made this clear. I appreciate ANY advice. Mostly what I'm looking for is a data model that will et me sort the elements in this way. I can then figure out the logic for moving them up and down, etc.
|
|
|
webguru22
Starting Member
USA
11 Posts |
Posted - 12/06/2000 : 17:54:08
|
Sorry, forgot the HTML is off on this forum. Here's what the outline would look like.
1.0 Top-level element
1.1 Second Level element
1.2 Second Level element
1.2.1 Third Level element
1.2.2 Third Level element
1.3 Second Level element
2.0 Top level element
2.1 Second Level element
2.2 Second Level element
2.3 Second Level element
2.3.1 Third Level Element
2.3.2 Third Level Element
2.3.2.1 Fourth Level element
2.3.3 Third Level Element
3.0 Top level element...
|
 |
|
|
robvolk
Most Valuable Yak
USA
15559 Posts |
|
|
graz
Chief SQLTeam Crack Dealer
USA
4128 Posts |
|
| |
Topic |
|
Data Model for "outline" format
