I am facing an issue with using two different syntaxes of the Yii query builder. The first syntax works perfectly but I cannot use variables inside the SQL.
$connection = Yii::app()->db;
$sql='SELECT id_activo, nom_activo, valor_activo, cod_amenaza, tipo_activo, deg_amenaza,
frec_amaneza FROM activo, amenazas WHERE amenazas.activos_amenaza ILIKE "%"|| activo.tipo_activo ||"%" AND id_activo=1';
$query = str_replace('"',"'",$sql);
$command = $connection->createCommand("$query");
$rows = $command->queryAll();
However, the second syntax does not display any results.
$i=1;
$rows = Yii::app()->db->createCommand()
->select('id_activo, nom_activo, valor_activo, cod_amenaza, tipo_activo, deg_amenaza, frec_amaneza')
->from('activo, amenazas')
->where('amenazas.activos_amenaza LIKE :substr', array(':substr' => '%activo.tipo_activo%'))
->andWhere('id_activo=:id', array(':id'=>$i))
->queryAll();
If I remove the where condition with the LIKE clause, it works fine.