nickchapin

SQL SELECT IN()

Discussion created by nickchapin on Aug 16, 2012
Latest reply on Aug 19, 2012 by Oliver_Reid

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

Outcomes