yii查询问题

  $connection = Yii::app()->db;        $table = $connection->tablePrefix.'insurance';        $sql = "select insurance_id, insurance_urlname from $table where insurance_display='Y' and insurance_status='A'";        $command = $connection->createCommand($sql);        $list = $command->execute();

回复讨论(解决方案)

execute （执行）
只用于无返回结果的场合