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.

All Forums  Development Tools  Other Development Tools  How to order a ResultSet?

Author  Topic  isowit Starting Member 1 Post Posted - 2006-04-26 : 11:44:20 In my database I stored about 200 projects. I plan to display this projects on a jsp-website. The projects are orderd hierarchically so the output should be hierarchically too. The projects are orderd like the follwoing example: 0 SEGMENT [YELLOW] 1- super-project [RED] 2-- sub-project [ORANGE] 3--- sub-sub-Project [GREEN] 4---- projectname [WHITE] Eine Ausgabe könnte aussehen: 0 SEGMENT A [YELLOW] 1- super-project [RED] 2-- sub-project [ORANGE] 3--- sub-sub-Project [GREEN] 4---- projectname [WHITE] 4---- projectname [WHITE] 4---- projectname [WHITE] 3--- sub-sub-Project [GREEN] 4---- projectname [WHITE] 4---- projectname [WHITE] 4---- projectname [WHITE] 2-- sub-project [ORANGE] 3--- sub-sub-Project [GREEN] 4---- projectname [WHITE] 4---- projectname [WHITE] 0 SEGMENT B [YELLOW] ... and so on I use Java in the jsp. All information are stored in a MS sql server 2000 database. the problem is to order the output hierarchically and mark the field with the spezific color like above. The output depends on the projects in the database. the classification of a project in the heirarchy is set by attributes. So a project has the attributes SEGMENT, super-project, sub-project, sub-sub-project and projectname. E.g. all projects with the same name in SEGMENT belongs to the same SEGMENT, all projects with the same name in sub-sub-Project belongs to the same sub-sub-Project and so on. How can I reach this? Do you know an example for that problem? I don't find a solution on my own.