cvs: pear /MDB2/MDB2/Driver/Manager mssql.php
| From: | David Coallier | Date: | Tue, 16 Aug 2005 23:07:04 +0000 |
| Subject: | cvs: pear /MDB2/MDB2/Driver/Manager mssql.php | ||
| Groups: | php.pear.cvs | ||
| Request: | Send a blank email to pear-cvs+get-34043@lists.php.net to get a copy of this message | ||
davidc Tue Aug 16 19:07:04 2005 EDT
Modified files:
/pear/MDB2/MDB2/Driver/Manager mssql.php
Log:
Fixed a type, re-put EXEC sp_tables and passed the test.
http://cvs.php.net/diff.php/pear/MDB2/MDB2/Driver/Manager/mssql.php?r1=1.31&r2=1.32&ty=u
Index: pear/MDB2/MDB2/Driver/Manager/mssql.php
diff -u pear/MDB2/MDB2/Driver/Manager/mssql.php:1.31 pear/MDB2/MDB2/Driver/Manager/mssql.php:1.32
--- pear/MDB2/MDB2/Driver/Manager/mssql.php:1.31 Wed Jul 27 12:05:49 2005
+++ pear/MDB2/MDB2/Driver/Manager/mssql.php Tue Aug 16 19:07:02 2005
@@ -42,7 +42,7 @@
// | Author: Frank M. Kromann <frank@kromann.info> |
// +----------------------------------------------------------------------+
//
-// $Id: mssql.php,v 1.31 2005/07/27 16:05:49 davidc Exp $
+// $Id: mssql.php,v 1.32 2005/08/16 23:07:02 davidc Exp $
//
require_once 'MDB2/Driver/Manager/Common.php';
@@ -275,7 +275,7 @@
return $db;
}
- $query = 'SELECT name FROM sysobjects WHERE xtype = \'U\'';
+ $query = "EXEC sp_tables";
$table_names = $db->queryCol($query, null, 2);
if (PEAR::isError($table_names)) {
return $table_names;
@@ -339,7 +339,7 @@
$pk_name = 'PK_NAME';
if ($db->options['portability'] & MDB2_PORTABILITY_LOWERCASE) {
$key_name = strtolower($key_name);
- $pk_name = strtolower($pk_name);
+ $pk_name = strtolower($pk_name);
}
$query = "EXEC sp_statistics @table_name='$table'";
$indexes_all = $db->queryCol($query, 'text', $key_name);
@@ -400,7 +400,7 @@
$result = $db->query("DROP TABLE $sequence_name");
if(PEAR::isError($result)) {
return $db->raiseError(MDB2_ERROR, null, null,
- 'createSequence: could not drop inconsisten sequence table ('.
+ 'createSequence: could not drop inconsistent sequence table ('.
$result->getMessage().' ('.$result->getUserInfo().
'))');
}