Remember that 'unchecked' checkboxes are not passed back to your CGI script. Your CGI script should set all values in the database to 'unchecked' unless the param is expicitly returned as 'checked'.

eg

 $checkboxes{$boxname} = defined($params{$boxname})?"true":"false"; 
#where $params is a hash of the parameters, keyed by name
#and $checkboxes is a hash of the values supplied to the sql
[download]

rdfield