diff options
| author | Derek Allard <derek.allard@ellislab.com> | 2007-12-18 16:58:03 +0100 |
|---|---|---|
| committer | Derek Allard <derek.allard@ellislab.com> | 2007-12-18 16:58:03 +0100 |
| commit | 694b5b8ee6a40b57c91be3c5448bc8f5540d32d8 (patch) | |
| tree | e79f794d18e31113ef086d76772c49c81b6b3cf1 /system/database/drivers/oci8 | |
| parent | 04036f33f6af540ce371b1ebd1878018f0816ed8 (diff) | |
Added count_all_results() function to Active Record.
Diffstat (limited to 'system/database/drivers/oci8')
| -rw-r--r-- | system/database/drivers/oci8/oci8_driver.php | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/system/database/drivers/oci8/oci8_driver.php b/system/database/drivers/oci8/oci8_driver.php index 99b5ded13..0cd04cc58 100644 --- a/system/database/drivers/oci8/oci8_driver.php +++ b/system/database/drivers/oci8/oci8_driver.php @@ -43,6 +43,13 @@ class CI_DB_oci8_driver extends CI_DB {
+ /**
+ * The syntax to count rows is slightly different across different
+ * database engines, so this string appears in each driver and is
+ * used for the count_all() and count_all_results() functions.
+ */
+ var $count_string = "SELECT COUNT(1) AS numrows ";
+
// Set "auto commit" by default
var $_commit = OCI_COMMIT_ON_SUCCESS;
@@ -389,7 +396,7 @@ class CI_DB_oci8_driver extends CI_DB { if ($table == '')
return '0';
- $query = $this->query("SELECT COUNT(1) AS numrows FROM ".$table);
+ $query = $this->query($this->count_string . "FROM ".$table);
if ($query == FALSE)
{
|