DataAssist Multiple Search same field

[siteontime]

I don't know what I am doing wrong, but I cannot get the multiple select list search to work.

I used the dataassist wizard to create a search and results page. I chose menu as the search option.

After the wizard was complete, on the search page I changed the menu to list and checked the allow multiple optiion.

I only get a list of first item selected. How can I get it to include all selections. The URL shows all 3.

HELP!!

I must be missing a step

[Ray Borduin]

Go to the results page and update the Search server behavior. Make sure it is specified as a type "list" in that interface. I think the Wizard does all type Value or Edit searches regardless of the form element because it doesn't directly support multiselect lists.

Should just be a matter of updating it in the server behavior at this point.

[siteontime]

No it is set to list. Here is the code.
$WADbSearch2_DefaultWhere = "";
if (!session_id()) session_start();
if ("" == "") {
$WADbSearch2 = new FilterDef;
$WADbSearch2->initializeQueryBuilder("MYSQL","1");
//keyword array declarations

//comparison list additions
$WADbSearch2->addComparisonFromList("minor_class_code","Category2","AND","=",0);

//save the query in a session variable
if (1 == 1) {
$_SESSION["WADbSearch2_LaundryProducts"]=$WADbSearch2->whereClause;
}
}
else {
$WADbSearch2 = new FilterDef;
$WADbSearch2->initializeQueryBuilder("MYSQL","1");
//get the filter definition from a session variable
if (1 == 1) {
if (isset($_SESSION["WADbSearch2_LaundryProducts"]) && $_SESSION["WADbSearch2_LaundryProducts"] != "") {
$WADbSearch2->whereClause = $_SESSION["WADbSearch2_LaundryProducts"];
}
else {
$WADbSearch2->whereClause = $WADbSearch2_DefaultWhere;
}
}
else {
$WADbSearch2->whereClause = $WADbSearch2_DefaultWhere;
}
}
$WADbSearch2->whereClause = str_replace("\\''", "''", $WADbSearch2->whereClause);
$WADbSearch2whereClause = '';

[Ray Borduin]

In php you need to add square brackets to the list name in your html before it will work with multiselect.

So <select name="myname"> needs to be updated to <select name="myname[]">

It appears the code is correct, so the problem has to be in the way the form element is named.

[siteontime]

Thank you Ray, that was the problem!! It was missing in the search page. Is it supposed to do that automatically? Maybe a bug?

[Ray Borduin]

It only needs to be added for multiselect lists. Since you changed it to a multiselect list, that is when you should have added the brackets. This is a general php thing. Any time you use a multiselect list in php you need to add brackets or it won't work. I suppose we could add them by default, but this is something you will need to know in general when working with multiselect lists in php (or checkbox groups).

[drostenator386534]

I've just spent two days looking for that answer. 2 little brackets. so simple. Thanks.

[nickj]

Can you point me to a tutorial or video or PDF which details multi select? Not sure where to find and how to apply.


Thanks

Nick