[ic] troubles with modified database
jamie at versado.net
Fri Sep 10 11:53:22 EDT 2004
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 :).
Jamie Neil | <jamie at versado.net> | 0870 7777 454
Versado I.T. Services Ltd. | http://versado.net/ | 0845 450 1254
More information about the interchange-users