Announcement

Collapse
No announcement yet.

Double Select as Criteria in SQL Statement not works

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

  • Double Select as Criteria in SQL Statement not works

    Hi
    i created a Double Select Field (called Zimmer) which contains a list of comma separated numbers. I want use this list in an other created Double Select Field as Lookup Criteria:

    Code:
    SELECT Name From User INNER JOIN Rooms on User.id=Rooms.userid WHERE Rooms.myRoom IN ({Zimmer});
    I checked the generated code on my server... the generated SQL Statement is like
    Code:
    SELECT Name From User INNER JOIN Rooms on User.id=Rooms.userid WHERE (Rooms.myRoom NOT IN ($zimmer_val_str)));
    So the query will not execute because of the 3 ")" instead of 2 ")" at the end. And also the stupid "NOT" i'm not understand. Thank's for fix that soon... takes me hours for testing.

    Best regards
    Steve

  • #2
    Looks like a bug to me. Please send this through to bugs@scriptcase.net
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      Good morning,

      As I replied you from email.

      We can't simulate the problem, I created a double select field with the sql bellow:
      SELECT
      cityname
      FROM
      city INNER JOIN states
      ON
      city.stateid = states.stateid
      WHERE
      states.statename IN ({cityid})


      the query is alike to your, and the query worked normally.

      What is error happens? show some error or just return the records?

      do you use which database?
      Please, send me the application and tables used for we check more better your problem, to email bugs@scriptcase.net


      Have a nice day.

      --
      Best Regard
      Netmake team
      Last edited by Artur Oliveira; 05-20-2015, 12:41 PM.

      Comment

      Working...
      X