5 Replies Latest reply on Aug 19, 2012 4:35 PM by Oliver_Reid

    SQL SELECT IN()

    nickchapin

      Does anyone know if the ExecuteSQL function will handle the IN() function? Either it doesn't or I can't get it to work. Here's the code:

       

      ExecuteSQL ( "SELECT field FROM table WHERE field2 IN ('a', 'b', 'c', 'n')"; ""; "" )

       

      The goal is to load an array for the IN that holds record IDs of a found set. Then I can use sql to "constrain" the records.

       

      TIA