Query list with array label

[timdaiYLHWA]

Hi

I have array label call Machine in list. I want get value from list where label "a" match Machine. How can I modify it.

[moehlmann_fe]

It works if you add the variable directly into the query string. I don't know why the $-syntax doesn't work in this case.

...WHERE '" + a + "' IN Machine

[joerg_vogel_HsH · Accepted solution]

a is a command. This can cause effects when the interpreter is building a query string. Typically nobody should use restricted names as local variable names. Other single character commands are i and c.