4 Replies Latest reply on Jan 16, 2017 11:01 AM by wfgclapp

    Is it possible to use a list condition in ExecuteSQL?


      Not sure how best to explain this, but the following non-working SQL statement should help illustrate.


      ExecuteSQL (

      "SELECT customer FROM ACTIVE_ACCTS WHERE field1=?";

      "" ;

      "" ;




      This obviously doesn't work, but what I'm trying to do is set my WHERE to be conditional on a field1's value being found within a list ($myList).


      Is there a way to do this in an ExecuteSQL statement?


      Thanks for any help.