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

Looks like you have a placeholder in your SQL statement (a placeholder is a question mark - "?") and you're not supplying a value for it in your execute statement. There doesn't appear to be enough information in your posts for a fuller explaination - you should post all of the relevent information:

rdfield

Replies are listed 'Best First'.
Re: Re: CGI/HTML checkboxes to SQL query
by Rachel (Acolyte) on Nov 27, 2002 at 09:19 UTC
    Okay this is an update on the problem. The good news is that I no longer get any errors. However, the script just goes ahead and executes the sql statement but without taking the form values into account. I will put this on my scratch pad, if anyone wants to take a look...... I would appreciate this. Thanks, Rachel
[reply]
      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);
}

      [download]

      rdfield

[reply]
[d/l]

In Section Seekers of Perl Wisdom