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

    Is it possible to use a list condition in ExecuteSQL?

    wfgclapp

      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=?";

      "" ;

      "" ;

      $myList

      )

       

      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.