Format of tables

[Darius Blaszijk]

Hello,

I have the following problem; In my application I have certain items that
have properties.

Item Property
--------- -----------------------
ToyBear Hairy, Soft, Brown
ToyCar Brown, Plastic, Wheels
ToyBall Round, Soft, Brown, Plastic

As you might expect I want to do queries on the properties; so property
Brown should yield all items listed above and Plastic should yield only
ToyCar and ToyBall.
The amount of properties is limitless, so making a separate field per
property seems to be madness. My question is how can I make a (or more)
tables that will enable me to search for items by applying one or more
properties?? What structure do I need to accomplish this?

Kind regards, Darius Blaszijk

[Alasdair]

--
please note email address requires editing

www.digitalmystic.co.uk

"Darius Blaszijk" <dh*********@zeelandnet.nl> wrote in message
news:41***********************@morenews.zeelandnet .nl...

Hello,

I have the following problem; In my application I have certain items that
have properties.

Item Property
--------- -----------------------
ToyBear Hairy, Soft, Brown
ToyCar Brown, Plastic, Wheels
ToyBall Round, Soft, Brown, Plastic

As you might expect I want to do queries on the properties; so property
Brown should yield all items listed above and Plastic should yield only
ToyCar and ToyBall.
The amount of properties is limitless, so making a separate field per
property seems to be madness. My question is how can I make a (or more)
tables that will enable me to search for items by applying one or more
properties?? What structure do I need to accomplish this?

Kind regards, Darius Blaszijk

don't know if this will help (im an sql newbie but a programming oldie :) )

first table :
Object name , Property pointer
second table :
Property

the property pointer of the first table would could be an integer and use
arithmetic to derive the property and vice versa

does that make sense? hope so :-)
Alasdair

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.726 / Virus Database: 481 - Release Date: 22/07/2004