Announcement

Collapse
No announcement yet.

Search Grid with Ajax Reload Using Checkbox Instead of Select (Filter Forms)

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Search Grid with Ajax Reload Using Checkbox Instead of Select (Filter Forms)

    I would like to be able to use a Search/Grid combination (Filter Forms) following the Scriptcase sample here (http://www.scriptcase.net/scriptcase...eld-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.
Working...
X