[ic] troubles with modified database
Patrick Donker
list-account at webpagina.nu
Fri Sep 10 18:15:33 EDT 2004
Jamie Neil wrote:
> Patrick Donker wrote:
>
>> I've added some extra colomns to my mysql products table to flag the
>> movie genre we sell. I have defined the colomns as Char(1) Binary null
>> default 0. What I'd like to do is using the UI flag the titles using
>> checkboxes on their respective genre. Most titles will have multiple
>> checkboxes set and colomn names are named after their genre. Trying to
>> achive this I have ran into some dificulties that I havent been able
>> to solve by both searching the archive and reading the docs.
>
>
> If you trying to do what I think, then we went down the same path and
> ended up doing it a different way.
>
> We wanted to be able to define a number of cross category groups such
> that a single product might belong to multiple groups. After a number of
> failed attempts our solution was to create a single field that stored
> zero or more group codes separated by spaces. This field could then be
> represented in the Admin UI using the "Checkbox (nbsp)" widget.
>
> I still don't like the idea of multivalued fields - it goes against the
> grain when you are using a RDMS - but it seems to work fine :).
>
Ok, I've got it working; thanks for getting me on my way!
While doing this I suddenly asked myself if it would be possible to
avoid setting conflicting genres. Ie if horror=1 it would be unlikely to
have set family=1. Is there a way to detect and prevent this?
-Patrick
More information about the interchange-users
mailing list