AnsweredAssumed Answered

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

Question asked by Doug Staubach on Oct 24, 2014
Latest reply on Oct 24, 2014 by philmodjunk

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
 

Outcomes