2
WHERE uid IN (1,2,3)
WHERE uname IN ('tom', 'dick', 'larry')
It is true that you don't want the quote around the whole brackets, but if you are using strings you'll need the quote around each element individually.
I guess you can force other parts of the code to put the quotes around the string elements, but I wonder if it would be better to have this built into the criteria class:
if (is_array($value)) {
return "('" . join("','", $value) . "')";
} else {
return "'$value'";
}
Also, I wonder if instead of just putting quotes (') around $value if we should pass it through $xoopsDB->quoteString???
