On Wed, Jul 31, 2002 at 10:46:24AM +1200, Rob Brown-Bayliss wrote:
> On Wed, 2002-07-31 at 02:34, Andrew Sullivan wrote:
> > Why not three codes: model, colour, and size? Then you can query all
> > by model, and limit by size, colour, or both.
>
> How do you mean three codes?
>
> If you mean having more than one product code for a type of shoe thats
> what I am trying to avoid.
Nope. A code for the product, and then other (optional) codes for
size and colour. So, you can query by maker, and by shoe type, and
by size, and by colour:
Show me all the things by bigcorp in style hotnow that are red and
size ten is something like
SELECT DISTINCT (shoename)
FROM shoecodes
WHERE maker = 'bigcorp'
AND shoename = 'hotnow'
AND size = 10
AND colour = 'red';
That's a crappy example, but you get the picture? This way you can
also get all the shoes in size ten, all the red shoes, or all the
shoes by so-and-so, or whatever.
A
--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M6K 3E3
+1 416 646 3304 x110