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 |
|
navs
Starting Member
13 Posts |
 Posted - 2007-07-25 : 08:22:49
|
| Hi All,Has anyone tried writing a db structure that would replicate a google notebook heirarchy?I'm very interested in learning to do this. My knowledge of MSSQL is poor. I had someone else develop a db in MSSQL for me. I'd like to add a similar functionality for my website to that of google notebooks. I don't need the browser plugins and stuff, only the ability to create new notes and sub notes which can have a few fields. For instance.A - History----a1.Name: World War 1----a2.Name: Germany 1918-1945----a3.Name: World War 2------a3i.Name: Causes of World War II------a3ii.Notes: bla bla bl a------a3iii.Description: These notes are about the causes of WWII------a3.SubTopic.a1.Name: Hitler's actions prior to WWII------a3.SubTopic.a1.Notes: notes notes notes------a3.SubTopic.a1.Description: desc desc descI need to develop a max of two level heirarchy for my website to provide my students a google notebook like functionality. I want to develop it for my school's website. Can someone help?Navs |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-25 : 13:43:02
|
| If the database is designed already, then isn't your question on how to code this in your application? If so, that would probably be better asked in a forum that deals with your programming language specifically (if .NET I suggest www.asp.net).Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
navs
Starting Member
13 Posts |
Posted - 2007-07-26 : 00:03:51
|
| I haven't designed it Tara. I wrote down what I'd like for my children to be able to do online on our school's website. I was wondering if someone could help write in MSSQL what I've written above as plain text.ThanksNavs |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2007-07-26 : 02:55:03
|
| This may have what you need[url]http://www.databaseanswers.org/data_models/index.htm[/url]steve-----------Don't worry head. The computer will do all the thinking from now on. |
|
|
|
nathans
Aged Yak Warrior
938 Posts |
|
|
|
|
|
Like Google notebook