mercredi 6 mai 2015

SQLite not working with criteria in Yii

This is my criteria code:

if ($this->title)
{
     $criteria->select = '*';
     $criteria->addCondition('title regexp :regexp');
     $criteria->params = array(':regexp'=>'[[:<:]]'.$this->title.'[[:>:]]');
}

When i'm connecting with db by MySQL in localhost, filtering wokrs fine, but when i'm using

'db'=>array(
    'connectionString' => 'sqlite:protected/data/blog.db',
    'tablePrefix' => 'tbl_',
    ),

then i get this message window always when trying to filtering in CGridView. enter image description here

Aucun commentaire:

Enregistrer un commentaire