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:

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

Looks like a bug to me. Please send this through to bugs@scriptcase.net

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