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:
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
SELECT Name From User INNER JOIN Rooms on User.id=Rooms.userid WHERE (Rooms.myRoom [B]NOT[/B] IN ($zimmer_val_str))[B])[/B];
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