504               return $result; 
 
 505           } 
 
 506           catch(Exception $e) 
 
 507           { 
 
 508               if($this->_connection->enableProfiling) 
 
 509                   Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query'); 
 
 510               $errorInfo = $e instanceof PDOException ? $e->errorInfo : null; 
 
 511               $message = $e->getMessage(); 
 
 512               Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.', 
 
 513                   array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand'); 
 
 514               if(YII_DEBUG) 
 
 515                   $message .= '. The SQL statement executed was: '.$this->getText().$par; 
 
  516               throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}', 
 
   517                   array('{error}'=>$message)),(int)$e->getCode(),$errorInfo); 
 
 518           } 
 
 519       } 
 
 520    
 
 521       /** 
 
 522        * Builds a SQL SELECT statement from the given query specification. 
 
 523        * @param array $query the query specification in name-value pairs. The following 
 
 524        * query options are supported: {@link select}, {@link distinct}, {@link from}, 
 
 525        * {@link where}, {@link join}, {@link group}, {@link having}, {@link order}, 
 
 526        * {@link limit}, {@link offset} and {@link union}. 
 
 527        * @return string the SQL statement 
 
 528        * @since 1.1.6