From 0aa6313662914dcead8adacf68bec3398c2e0dc7 Mon Sep 17 00:00:00 2001 From: xue <> Date: Fri, 23 Feb 2007 14:36:02 +0000 Subject: Added TDbCache. --- framework/Data/TDbCommand.php | 17 ++++++++--------- 1 file changed, 8 insertions(+), 9 deletions(-) (limited to 'framework/Data/TDbCommand.php') diff --git a/framework/Data/TDbCommand.php b/framework/Data/TDbCommand.php index 102bdf34..f5d7d647 100644 --- a/framework/Data/TDbCommand.php +++ b/framework/Data/TDbCommand.php @@ -180,7 +180,9 @@ class TDbCommand extends TComponent { try { - Prado::trace('Execute Command: '.$this->getDebugStatementText(), 'System.Data'); + // Do not trace because it will remain even in + // Performance mode or when pradolite.php is used + // Prado::trace('Execute Command: '.$this->getDebugStatementText(), 'System.Data'); if($this->_statement instanceof PDOStatement) { $this->_statement->execute(); @@ -216,7 +218,7 @@ class TDbCommand extends TComponent { try { - Prado::trace('Query: '.$this->getDebugStatementText(), 'System.Data'); + // Prado::trace('Query: '.$this->getDebugStatementText(), 'System.Data'); if($this->_statement instanceof PDOStatement) $this->_statement->execute(); else @@ -241,7 +243,7 @@ class TDbCommand extends TComponent { try { - Prado::trace('Query Row: '.$this->getDebugStatementText(), 'System.Data'); + // Prado::trace('Query Row: '.$this->getDebugStatementText(), 'System.Data'); if($this->_statement instanceof PDOStatement) $this->_statement->execute(); else @@ -260,24 +262,21 @@ class TDbCommand extends TComponent * Executes the SQL statement and returns the value of the first column in the first row of data. * This is a convenient method of {@link query} when only a single scalar * value is needed (e.g. obtaining the count of the records). - * @return mixed the value of the first column in the first row of the query result. + * @return mixed the value of the first column in the first row of the query result. False is returned if there is no value. * @throws TDbException execution failed or there is no data */ public function queryScalar() { try { - Prado::trace('Query Scalar: '.$this->getDebugStatementText(), 'System.Data'); + // Prado::trace('Query Scalar: '.$this->getDebugStatementText(), 'System.Data'); if($this->_statement instanceof PDOStatement) $this->_statement->execute(); else $this->_statement=$this->getConnection()->getPdoInstance()->query($this->getText()); $result=$this->_statement->fetchColumn(); $this->_statement->closeCursor(); - if($result!==false) - return $result; - else - throw new TDbException('dbcommand_column_empty'); + return $result; } catch(Exception $e) { -- cgit v1.2.3