AnsweredAssumed Answered

executeSQL ... WHERE ID IN (?)

Question asked by f.i.sciences on Feb 16, 2018
Latest reply on Feb 16, 2018 by f.i.sciences

Hello,

 

I have tried the following with no result :

     ExecuterSQL ( "SELECT \"Nom\" FROM \"Employés\" WHERE ID IN (?)" ; ";" ; "¶" ; Substituer ( $$list ; "¶" ; "," ) )

Return blank, $$list = "2¶4¶8".

 

     ExecuterSQL ( "SELECT \"Nom\" FROM \"Employés\" WHERE ID IN (?)" ; ";" ; "¶" ; "2,4,8" )

Return blank also.

 

If I do:

     ExecuterSQL ( "SELECT \"Nom\" FROM \"Employés\" WHERE ID IN (2,4,8)" ; ";" ; "¶" )

Return 3 names.

 

What I'm doing wrong here?

Thank you.

Outcomes