5 Replies Latest reply on Oct 24, 2014 3:33 PM by philmodjunk

    We can't seem to make the following statement work at all. ExecuteSQL ( " SELECT * FROM...

    Doug Staubach

      Post

      We can't seem to make the following statement work at all.

      ExecuteSQL ( "

         SELECT *
         FROM People
         WHERE EmployeeID IN (?)
      " ; "" ; "" ; "'010907','010489'"
      )

       

      However, this one works perfectly:

      ExecuteSQL ( "

         SELECT *
         FROM People
         WHERE EmployeeID IN ('010907','010489')
      " ; "" ; ""
      )

      What are we doing wrong?

      Thanks,
      Doug