Trying to implement multiselect, but there is one massive issue with it. It passes in a new argument for each item selected. mysql does not support variable parameters.

I EXPECTED it to pass in all selected items in a comma delimited string to a SINGLE variable so I could break it into an array and do WHERE IN array in mysql.

Is this already possible? Am I missing something?

So I have this multi-select:

<label>Select Opportunity Status</label> <br>
<?php
    MultiSelect::create(array(
        'name'=>"OppStatus",
        "placeholder"=>"Select Opportunity Status",
	"dataStore"=>$this->dataStore("oppStatus"),
	"dataBind"=>array(
	    "text"=>"opportunityStatusDesc",
	    "value"=>"opportunityStatusId",
	),
	"attributes"=>array(
	"size"=>5,
    )
));
?>

When I select multiple values, I get this error: usp_AgenciesWhoPostedOpportunities('1','3','4', '1', '2017-07-01 00:00:00', '2017-07-31 00:00:00');

The proc is expecting these params: usp_AgenciesWhoPostedOpportunities(IN OppStatus char, IN OrgStatus char, IN StartDate, IN EndDate datetime)

In the error, I selected three items from the multi-select. As you can see, it added 1, 3 and 4 to the params list. I expected it to call the proc like this: usp_AgenciesWhoPostedOpportunities('1,3,4', '1', '2017-07-01 00:00:00', '2017-07-31 00:00:00');

Notice how the first param is a list of the IDs

I figured out a work-around, but seriously this control should be sending in a string of comma delimited items, not trying to insert them as new params for each item selected. Solution:

":OppStatus"=>implode(",",$this->params["OppStatus"]),