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 |
|
bardman6
Starting Member
3 Posts |
 Posted - 2007-11-29 : 17:00:19
|
| Hello folks...I have a question for ya all. I am building an interactive tourism site that allows for users to build an itinerary and save in their account. I have had little luck in defining the architecture of this. I have accommodations with 4 sub categories (hotels, b&bs, condo rentals, and camping), attractions (a couple of theme parks, shopping areas, and other things to do), outdoor activities with 15 sub categories, and a few other things. I am not sure exactly how to set this up. To further complicate this, some of the activities/attractions overlap (for example some of the hotels also have camping available), but I still want the final itinerary have it listed in the category it was selected in. I am using Classic ASP and SQL 2000 (this is what the rest of the site is built in). I am moderately experienced in SQL, but this is way beyond anything I have done before.... Some help please?Thanks in advance.-->geek<-- |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-30 : 03:35:51
|
| I guess you already have the categories and sub categories set up?If these are all out of 1 table, then just simply save a record for that user with their user information, then the category and sub categoryid and a date or similar.Do this for each attraction they chose and then on the recall you can get all the records back in the correct order using the date. |
 |
|
|
|
|
|
|
|
I need some advice