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 |
|
cez
Starting Member
37 Posts |
 Posted - 2002-10-01 : 17:39:58
|
| Hi !Please help me with something: i'm building a site and i need to store the properties for some products in the db. The properties are given so I have to design a table. But how can I do it, since a property can be OR a simple text, OR a simple value, OR have both min. and max. values, OR have multiple options ( a select with the possibilites to select more than one ..) .. Do you have any idea ?Thanks. |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-10-01 : 18:12:41
|
| How about posting some example values so we can get an idea of exactly what you're trying to do?--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
mdudash
Starting Member
1 Post |
Posted - 2002-10-01 : 20:13:04
|
| Look, give us a little more info so a "real" answer can be provided. At least post what DBMS your using. I'm going to take a shot at this anyway:It sounds like you need a flexible way to store records with a variable number of "fields". MS Site Server / Commerce Server solves this problem in a very cool way. It wraps up the variable fields that define a specific product using an XML recordset and storing that in a single field. Commerce server provides a decent interface to define the fields for any type of product. Then creates an "interpreter" class to handle db access for the app at runtime.Mike DudashSenior Programmer/Analyst Healthmaster, Inc. |
|
|
|
|
|
|
very complicated table design