When using an SQL IN statement within a ColdFusion query, it is necessary to add the attribute
list="true" to the param used for the list. See the example below that selects all employees that have a birthdate in March, April or May.
1 2 3 4 5 6 7 8 9 10 11
Thanks to Ben Nadel’s post here for this crucial tidbit of information!