ID: 41399 Updated by: [EMAIL PROTECTED] Reported By: geniuz at geniuz dot cz -Status: Open +Status: Assigned Bug Type: PDO related Operating System: XP PHP Version: 5.2.2 -Assigned To: +Assigned To: wez
Previous Comments: ------------------------------------------------------------------------ [2007-05-15 15:22:27] geniuz at geniuz dot cz I found now that I can't call odbc_result function more than one time, only first call return me data from TEXT type column. So it is possible that PDO implements more than one call of odbc_result for TEXT type columns...? ------------------------------------------------------------------------ [2007-05-15 14:28:12] geniuz at geniuz dot cz Description: ------------ I have column type TEXT. When I read it over odbc_result, it works fine. When I read it over PDO, column is empty. More, all next readed columns after this column are empty too. For example: SELECT ID, CSN, Spec FROM MYTABLE When CSN column type is TEXT, I obtain empty data for CSN a Spec columns. I have downloaded http://snaps.php.net/win32/php5.2-win32-latest.zip before I send this bug. Reproduce code: --------------- if($sth = $pdo->query( "SELECT ID, CSN, Spec FROM MYTABLE" )) { while( ($row = $sth->fetch(PDO::FETCH_NUM)) ) { echo "ID:".$row[0]."<BR>"; echo "CSN:".$row[1]."<BR>"; echo "Spec:".$row[2]."<BR>"; } } Expected result: ---------------- Not empty $row[1] and $row[2] Actual result: -------------- Empty $row[1] and $row[2] ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=41399&edit=1
