Querying multiple values in a search form

Applications Grid / Reports
#1

Hello,

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 correspondending 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?

#2

Am i alone with this question???

#3

you could fix that in a simply manner, but to assure you that i need you to post your query in here plz, print screens on your search conf would also be helpful

Regards

#4

Sorry but i don’t know what you mean witch “search conf”. Can you explain it?

Regards

#5

[FIXED] I solved the problem with a trick: I use “var-0 as var” in the query of the grid. So I force ScriptCase outputting the variable numerically.

#6

I have the same issue right now. I see your solution but don’t understand it. Can you elaborate where and what code to change ? Some screenshots would be nice - thanks