#38870 [NEW]: Die on INSERT command using MSSQL_Query
From: howardt at calhounisd dot org
Operating system: Windows XP, Windows Server 2000
PHP version: 4.4.4
PHP Bug Type: MSSQL related
Bug description: Die on INSERT command using MSSQL_Query
Description:
------------
When running an INSERT command through MSSQL_Query, the transaction is
successful (the record is inserted) but the script immediately dies ("OR
die(...)" is executed). I have followed what documentation I can find on
the PHP site, but it dies every time. This does not occur on SELECT or
UPDATE commands.
Reproduce code:
---------------
<?
$MSSQL_Link = MSSQL_Connect($DistrictServer, "UserID", "password");
MSSQL_Select_DB($DistrictServerDB, $MSSQL_Link);
$Insert_Query = "INSERT INTO table(SchoolID, StateID)
VALUES('$StudentNum', '$stateid')";
$Insert_Result = MSSQL_Query($Insert_Query, $MSSQL_Link) OR die("Could not
insert record. " . $Insert_Query);
echo "Success";
?>
Expected result:
----------------
"Success" should be displayed on the page.
Actual result:
--------------
"Could not insert record. INSERT INTO table(SchoolID, StateID)
VALUES('123456', '987654')" is displayed instead.
--
Edit bug report at http://bugs.php.net/?id=38870&edit=1
--
Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=38870&r=trysnapshot44
Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=38870&r=trysnapshot52
Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=38870&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=38870&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=38870&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=38870&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=38870&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=38870&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=38870&r=support
Expected behavior: http://bugs.php.net/fix.php?id=38870&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=38870&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=38870&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=38870&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=38870&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=38870&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=38870&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=38870&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=38870&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=38870&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=38870&r=mysqlcfg
Thread (6 messages)
- howardt at calhounisd dot org