I want to query multiple values in a search form with a checkbox. The field type is varchar. The depending form writes via checkbox-field for example the following values to a database field [field_x_y_z values (1;3;7)]. In the search application while accessing the corresponding checkboxes there will be no result. In the log of the webserver the query will be executed as ‘select * from table where field in (‘1’,‘3’,‘7’)’. This will cause in no result. The correct query string may be ‘select * from table where field in (1,3,7)’. Is this a bug or a mistake by myself?
Someone in the forum said this could be fixed by a trick: ie use “var-0 as var” in the query of the grid. So I force ScriptCase outputting the variable numerically. But I don’t understand this solution or If I did, if it works.
I need either an explanation of the trick above, or some different solution, or a fix to a bug if it exists. HELP !