#34080 [Fbk->Opn]: recordset crash on trim and on fields with value null

ID: 34080 User updated by: mihkel at art dot tartu dot ee Reported By: mihkel at art dot tartu dot ee -Status: Feedback +Status: Open Bug Type: COM related Operating System: MS-Win2000 SP4 PHP Version: 5.0.4 New Comment: The crash is gone now. (for both trim and null fields) BUT. fields with the value NULL return now 'Object id #4' which doesn't sound right. Am i missing somethig and it is suposed to do so? (i would prefer 'NULL' or '' as return value) Previous Comments: ------------------------------------------------------------------------ [2005-08-11 13:22:38] sniper@php.net Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip ------------------------------------------------------------------------ [2005-08-11 13:15:04] mihkel at art dot tartu dot ee Description: ------------ Database: MS-SQL Server 2000 (in case it is important) See code below. Expecting it to NOT hang forever and produce some output. Unfortunately - if ANY of the lines with crash comment behind them is present it will hang forever (until web-server timeout). 'user' - is a present field of type char(20) and value is never NULL. 'kursjuh' - is a present field of type char(1) and will result a crash only if field value is NULL. PHP fails to produce error log - so, no info there. Reproduce code: --------------- $db=new COM("ADODB.Connection"); $db->Open("Driver={SQL Server};Server=***;Database=***;"); $dta=$db->Execute("SELECT * FROM Qigus"); while(!$dta->EOF) { echo $dta->Fields['kursjuh']->Value; // crash echo $dta['kursjuh']; // crash echo $dta['user']; // works fine echo trim($dta['user']); // crash $dta->MoveNext(); } ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=34080&edit=1