AnsweredAssumed Answered

Is it possible to use a list condition in ExecuteSQL?

Question asked by wfgclapp on Jan 16, 2017
Latest reply on Jan 16, 2017 by 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.

Outcomes