Criteria condition params - Quick question about SQL IN condition

Yii 1.1 General Discussion
1

How do I use ‘IN’ as a condition with a string of values

IE:




		$criteria->select = 'post_id, post_username, post_text';

		$criteria->condition = 'topic_id=:topic_id AND post_id IN (:posts)';

		$criteria->params = array(

		       'topic_id'=>$topicID,

			   'posts'=>'12,36,40',

			   );

Only gives the results for the first number

2 



$criteria->select = 'post_id, post_username, post_text';

$criteria->compare('topic_id', $topicID);

$criteria->addInCondition('post_id', array(12,36,40));