For some reason this took me some effort to figure out. Maybe others will find it useful.
CategoryList = '1,2,3'; Categories = ormExecuteQuery("from Category where Id IN (:IdList)",{IdList=ListToArray(CategoryList)});
If you know a better way please drop me a comment. I posted this in the Adobe Coldfusion forum for a few days but didn’t get anything.