[ic] troubles with modified database

Jamie Neil 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 mailing list