Quote from: airoctive at Aug 26, 2009, 03:04 PM
I tried using your code above but I receiving an error in the prepared sql. Looks like the bound value in the IN clause is being escaped using ’. Is there any way to get around this?
ATM, the :IN clause is not working for the reason you describe; when refactoring some issues with quoting last year with prepared statements, I broke this capability. It’s on my list to address, but in the meantime, you can simply include the full expression (avoiding the use of the prepared statement parameter), like so:
$events= $xpdo->getCollection('Events', array ("id IN (2080,2081,2082,2083,2084,2085)"));
MODX Staff