Announcement

Collapse
No announcement yet.

Querying multiple values in a search form

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

  • Querying multiple values in a search form

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

    Comment


    • #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

      Comment


      • #4
        Sorry but i don't know what you mean witch "search conf". Can you explain it?

        Regards

        Comment


        • #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.

          Comment


          • #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

            Comment

            Working...
            X