Bug #9625

Inserts doesn't work with MDB2 mssql driver

Details

Submitted	2006-12-15 06:50 UTC
From	bbambuk at yandex dot ru
Assigned	alan_k
Status	Closed
Package	DB_DataObject
PHP Version	Irrelevant
OS	irrelevant
Roadmaps	(Not assigned)

Comments

[2006-12-15 06:50 UTC] bbambuk at yandex dot ru

Description:
------------
MDB2 use queryOne method to get single value from db.

DataObject.php, function insert, row 1058
$mssql_key = $DB->getOne("SELECT @@IDENTITY");

change to:
if(($_DB_DATAOBJECT['CONFIG']['db_driver'] == 'MDB2'))
{
$mssql_key = $DB->queryOne("SELECT @@IDENTITY");
}
else
{
$mssql_key = $DB->getOne("SELECT @@IDENTITY");
}

Expected result:
----------------
single value from the db

Actual result:
--------------
undefined function