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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-10 : 14:50:11
|
Demir writes "Hi,
I am trying to build a search engine which has a category structure like a tree. A main category, then a few sub of the main, and some subs of the sub and so on. I desinged 2 tables,
TB_Url & TB_Category. The TB_Url is the table where Url info is stored such as adress, category, site title... The TB_Category stores the category information: category name, parent. My problem starts here. An adress can be an element of 2 or more categories. I solved my problem by entering the category IDs in TB_Url like ',1,2,3,4' and query the table " where Category like ',1,1' ". This works fine for now. But when it comes to updating info, this structure causes troubles. I wonder if you can recommend something better.
Thanks
Demir" |
|
|
|
|
|
A portal via tree style category organization