[ic] troubles with modified database
list-account at webpagina.nu
Fri Sep 10 13:00:26 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 :).
That would be indeed a creative solution. But I also have to agree with
you that something we both would like to implement is a rather basic
functionality. I cant imagine that setting a value using a checkbox into
a database isnt possible using IC. Why then would a checkbox function be
implemented if it doesnt work...
Maybe one of the IC gurus here have a solution?
More information about the interchange-users