#100 Handling of IN during Select operation

3.1.0
closed-wont-fix
Common (150)
5
2010-11-24
2010-11-23
Anonymous
No

When trying to use the IN operator to select items with the Select: workflow The arguments that I enter in the text box are not what are used or displayed in the query below.

In the attached screenshot I show how when I used an IN of "PK3991","PK3992" it translated this to just 3991,3992 Chopping off parts of in this case an item number, thus changing the query to something that will return an empty set in my data.

Discussion

  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous - 2010-11-23

    screenshot showing how the entered data is not used in the query

     
  • Jakub Vrána

    Jakub Vrána - 2010-11-24

    Use apostrophes because quotes can be configured as identifier delimiter. 'PK3991','PK3992' should work.

     
  • Jakub Vrána

    Jakub Vrána - 2010-11-24
    • status: open --> closed-wont-fix
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks