summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorxue <>2007-10-06 21:48:38 +0000
committerxue <>2007-10-06 21:48:38 +0000
commite4320cab263a45f8920599d5c919230309e7284c (patch)
treeeaa96c8cb2e5470897eade01d6caf9f49a5f9438
parentf8131d4a0169c65eb148437827726624fca1a7f6 (diff)
Added TDbCommand.queryColumn()
-rw-r--r--HISTORY1
-rw-r--r--framework/Data/TDbCommand.php17
2 files changed, 18 insertions, 0 deletions
diff --git a/HISTORY b/HISTORY
index fd1462ff..38bdd3f8 100644
--- a/HISTORY
+++ b/HISTORY
@@ -1,6 +1,7 @@
Version 3.1.2 To be released
============================
CHG: Changed TConditional so that the controls in its template behave like they are in its parent (Qiang)
+ENH: Added TDbCommand.queryColumn() (Qiang)
NEW: Added TDbLogRoute (Qiang)
NEW: Added TDataRenderer and TItemDataRenderer (Qiang)
diff --git a/framework/Data/TDbCommand.php b/framework/Data/TDbCommand.php
index f5d7d647..b4bd9dd4 100644
--- a/framework/Data/TDbCommand.php
+++ b/framework/Data/TDbCommand.php
@@ -283,6 +283,23 @@ class TDbCommand extends TComponent
throw new TDbException('dbcommand_query_failed',$e->getMessage(),$this->getDebugStatementText());
}
}
+
+ /**
+ * Executes the SQL statement and returns the first column of the result.
+ * This is a convenient method of {@link query} when only the first column of data is needed.
+ * Note, the column returned will contain the first element in each row of result.
+ * @return array the first column of the query result. Empty array if no result.
+ * @throws TDbException execution failed
+ * @since 3.1.2
+ */
+ public function queryColumn()
+ {
+ $rows=$this->query()->readAll();
+ $column=array();
+ foreach($rows as $row)
+ $column[]=current($row);
+ return $column;
+ }
}
?> \ No newline at end of file