print div({-class=>'taskcolumnleft'}, h3("Chair(s) of
$name committee"), start_form({-action=>"/memberarea/cmt/members/edit/"}), hidden(-name=>'requestID',-value=>$requestID), $currentchairlist, submit(-name=>'submit',-value=>'Remove Chairs')); end_form; print div({-class=>'taskcolumncenter'}, h3("Current Members of
$name committee"), start_form({-action=>"/memberarea/cmt/members/edit/"}), hidden(-name=>'requestID',-value=>$requestID), scrolling_list(-name=>"currmembers", -value=>$mbrArray, -size=>20, labels=>$mbrHash, -multiple=>"true"), p( [ submit(-name=>'submit',-value=>'<<= Assign as Committee Chair'), submit(-name=>'submit',-value=>'Remove Members =>>') ]), end_form); } print div({-class=>'taskcolumnright'}, h3("Members
(not on this committee)"), start_form({-action=>"/memberarea/cmt/members/edit/"}), hidden(-name=>'requestID',-value=>$requestID), scrolling_list(-name=>"addmember", -value=>$nocIDArray, -size=>20, labels=>$nocNameHash, -multiple=>"true"), p(submit(-name=>'submit',-value=>'<<= Add Members')), end_form); #### sub add_members { foreach (@addmembers) { my $sql = "INSERT INTO cmt_members (CmtID, MemberID)"; $sql .= "VALUES ($requestID, $_)"; my $sth = $dbh->prepare($sql) || die "Error preparing: $DBI::errstr"; $sth->execute || die "Error executing: $DBI::errstr"; } } sub remove_members { print p("we're in the remove members function"); foreach (@currmembers) { print p($_); my $sql = "DELETE FROM cmt_members WHERE MemberID = $_ and CmtID = $requestID"; print p($sql); $sth = $dbh->prepare($sql) || die "Error preparing: $DBI::errstr"; $sth->execute || die "Error executing: $DBI::errstr"; $requestID = $requestID; } }