--
please note email address requires editing
www.digitalmystic.co.uk
"Darius Blaszijk" <dhkblaszyjk@zeelandnet.nl> wrote in message
news:41060ebd$0$13555$fb624cd1@morenews.zeelandnet .nl...[color=blue]
> 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[/color]
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
