in reply to Re: Re: CGI/HTML checkboxes to SQL query
in thread CGI/HTML checkboxes to SQL query

It would be best to add the code on your scratchpad to the end of your previous node: for posterity, you know. Anyway, the problem seems to be with the HTML (as originally pointed out by theorbtwo in the CB): you have named all of your checkboxes "drive", so in order for your code to work you need something like (and this is untested):
my %hash = (Initiative=>'DriveInitiative', ResOrientation => 'DriveResOrient', Creativity => 'DriveCreativity', ChangeOrientation => 'DriveChangeOrient', DecisionMaking => 'DriveDecisionMake', SelectLevel => 'ResLevel', ManagesPeople => 'ResManage'); my @checked = split /\0/,$cgi->param('drive'); my @clauses; foreach my $checkbox (@checked) { push @clauses, $hash{$checkbox} if validate($checkbox); }

rdfield