[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] Categories - one product in multiple categories
On Fri, Mar 02, 2001 at 05:35:28PM -0700, Ryan Hertz wrote:
>
> >cfm@maine.com wrote:
> > >
> > > On Fri, Mar 02, 2001 at 12:30:43PM -0800, nwcorp@helpwizard.com wrote:
> > > > Does anyone know the magic trick for allowing one product to appear in
> > > > multiple categories? Can't seem to find any info in the .pdf files or
> > > > here among the users.
> > >
> > > keep the list of categories in which any particular product belongs
> > > in a separate table and JOIN
> >
> >Alrternatively, a somewhat simpler way of doing this is to set up
> >multiple category columns
> >
> >eg
> >
> >sku desc cat_1 cat_2 cat_3
> >1 this none blue
> >2 that all red
> >3 other all blue
>
> Couldn't you just have:
>
> sku desc category foobar
> 10 Voop can,bottle blah
Voop? :-)
Is that available in tall boys or just 16 oz cans?
--
Christopher F. Miller, Publisher cfm@maine.com
MaineStreet Communications, Inc 208 Portland Road, Gray, ME 04039
1.207.657.5078 http://www.maine.com/
Content management, electronic commerce, internet integration, Debian linux
_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users
