How To Set Criteria Params Parameter Type?

Yii 1.1 General Discussion
1

My dataprovider:




$dataProvider = new CActiveDataProvider('Record', array(

            'criteria' => array(

                'condition' => 'example1= :example1 AND example2= :example2',

                'params' => array(':example1' => $example1,

                                  ':example2'=> $example2,

                                 ),

                ),

		 'sort'=>array(

		    'defaultOrder'=>'time ASC',

	      )

            )

        );

How to set the params pdo tpye? E.g. string, number …

2

Hi

could you give us an example, what do you want to do?

3

I wanna use this syntax (cdbcommand):

$sql_state->bindValue(’:id’, $id, PDO::PARAM_STR);

4

Why you want to do that on CActiveDataProvider ?

As you wrote you can do that by


 'params' => array(':example1' => $example1,

                         ':example2'=> $example2,

                                 ),