I would like to be able to use a Search/Grid combination (Filter Forms) following the Scriptcase sample here (http://www.scriptcase.net/scriptcase-samples/php-filter-search/reload-field-with-ajax/), but I would like to use checkboxes instead of selects (dropdown). When I switch the field from Select to Checkbox, I get SQL errors. My guess is the format returned from a checkbox field is different from a select field even though I structured my SQL like this:
SELECT DISTINCT attr3
FROM maindataview
WHERE attr2 IN (‘Location 2’,‘Location3’)
attr2 is where Location is chosen. Originally, I tried {attr2} and variants (with single quotes, parentheses), but nothing worked.
Does anyone know if this is possible? Any clues as to the format returned? Looking at the SQL in debug mode shows a broken IN clause, but nothing about the search field (checkbox) itself.