[ic] troubles with modified database

Patrick Donker list-account at webpagina.nu
Fri Sep 10 11:12:43 EDT 2004


Hi people,

I hope that my problem has a simple solution.
What I'm trying to do is the following:
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.

- How do I make a checkbox show up in the UI in such a way that checking 
it will set 1 into the proper colomn? I have tried this using the 
mv_metadata.asc file, but that is hard, to say the least. Looks like the 
checkbox isnt used in any of the examples in that file. If I create the 
following entry, the result is that there are 2 checkboxes are displayed 
followed by a 0, but if I check them, they dont do anything; the colomn 
value is unchanged. I havent been able to find out from the docs where 
and how entries are made into the database from within UI.

products::action	checkbox	20			products					Genre		action	nullselect	

						
I'm sire you'll need more information to help me out, so please ask for 
whatever info missing

TIA
-Patrick


More information about the interchange-users mailing list