category tree like structure
ASP.NET
1
Posts
1
Posters
0
Views
1
Watching
-
i am building a category tree like structure for my FAQ app. i need to show all active categories. The hitch is that if a parent category is checked as inactive, then the sub or child categories under it should not be displayed even if they are marked as active. I need a query which will return me such a resultset which i can display in a table. the columns in my table are categoryid, category, ParentcategoryID,companyID and active. The ParentcategoryID contains id of another category or 'No parentcategory' which denotes its the main category. It is easy to get the immediate parentcategory and find out if its active or not. But to find out if that parent category's parent and so on is active or not is tough. please help.