Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raisor
Starting Member
28 Posts |
 Posted - 2004-04-23 : 03:31:09
|
| Hello everyone,I'm probably trying to accomplish the impossible :D, but then again I'm SURE someone has done this before or knows about site where the present this somewhere.I've looked at the SQL for threaded discussions forum @ http://www.sqlteam.com/item.asp?ItemID=1353 and am now to the point where I want to extend it a little bit. There are many TREEVIEW components for ASP.NET and ASP, but I want to keep it in SQL (to answer someone's question on why not just do it in a asp/asp.net page).Instead of the spaces used in the example I would like to create a tree as follows:root|-folder1| |-link1| |_link2|-folder2|_folder3etc. etcI'm sure you'll get the idea......the problem isn't so much accomplishing this, but having problems on when to display a certain image, as of like when it's the last thread it should have a closing image instead of a join image. And also (as for example) under folder 1 there comes folder 2 and 3 so there should be lines on the side going down.I've been reading some about FETCH NEXT ROW etc. etc. but could someone point me in the right direction somewhere on how to accomplish this?THANKS!!! |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-04-23 : 11:52:57
|
quote:
Originally posted by Merkin
Have an experiment with this http://www.sqlteam.com/item.asp?ItemID=8866I've done something similar with this technique once.Damian
Yeah but did you ever see a follow up article? Or are we just waiting for Yukon?Which is when exactly? And what does it cost to upgrade?Brett8-) |
 |
|
|
|
|
|
Threading with SQL