#19841 [NEW]: RPC stored procedure with many columns return null value

From: tonyho@fairex.com Operating system: Sun Solaris 8 PHP version: 4.2.3 PHP Bug Type: Sybase (dblib) related Bug description: RPC stored procedure with many columns return null value Hi, I am building a interface to execute a stored procedure on a WAN Sybase ASE 12.0 from a local Sybase ASE 12.0. However, the result is null when the stored procedure returned too many columns data. This works fine on a local Sybase ASE. ----------- SYBASE ------------ Column_name Type Length Prec --------------------- -------- ------ ---- TradeID varchar 20 NULL OrderID varchar 20 NULL SubOrderID int 4 NULL CurrencyPair char 6 NULL Rate float 8 NULL BuySell char 1 NULL CCY1Amount float 8 NULL DealDateTime datetime 8 NULL OriginatorID varchar 10 NULL TradeType char 1 NULL CCY2Amount float 8 NULL TraderID varchar 10 NULL ValueDate datetime 8 NULL Status char 2 NULL IMargin float 8 NULL MMargin float 8 NULL Commission float 8 NULL RatePips float 8 NULL Lots float 8 NULL SquareGroupID varchar 20 NULL HouseRatePips float 8 NULL AcceptedBy varchar 10 NULL LastChangedBy varchar 10 NULL DateTimeLastChanged datetime 8 NULL AdjustingPips float 8 NULL CreationDate datetime 8 NULL SquaredPNL float 8 NULL GeneratedBy varchar 4 NULL drop procedure sp_test go create procedure sp_test @idstring varchar(15) = NULL as select TradeID, OrderID, SubOrderID, CurrencyPair, Rate, BuySell, CCY1Amount, DealDateTime, OriginatorID, TradeType, CCY2Amount, TraderID, ValueDate, Status, IMargin, MMargin, Commission, RatePips, Lots, SquareGroupID, HouseRatePips, AcceptedBy, LastChangedBy, DateTimeLastChanged, AdjustingPips, CreationDate, SquaredPNL, GeneratedBy from Trades where TradeID like @idstring go grant execute on sp_test to user go ------------ PHP -------------- <? $intSecurity = 3; $intTimeOut = 1800; $cmd = $HTTP_GET_VARS['cmd']; $cmd = ereg_replace("\\\'", "'", $cmd); $cmd = ereg_replace('\\\"', '"', $cmd); print("<table border=1><tr><th>Command</th>\n"); printf("<td>%s</td></table><br>\n",$cmd); sybase_connect("sybase","user","user"); $result = sybase_query("$cmd"); //$result = sybase_query("exec syb2...sp_test 'idstr'"); //if ( $result == NULL ) //print("Null result..."); // // Print Heading In Table Format // print("<table border=1>"); while ($row = sybase_fetch_field($result)) { printf("<th>%s</th>", $row->name); } // // Print Data In Table Format // $j = sybase_num_fields($result); while ($row = sybase_fetch_array($result)) { print("<tr>"); $i = 0; while ($i < $j) { if ( $row[$i] == NULL ) printf("<td><br></td>"); else printf("<td>%s</td>", $row[$i]); $i++; } print("</tr>\n"); } print("</table><br>"); // // Print Sybase Error Message // print("<table border=1>"); $err = sybase_get_last_message(); //if ( $err != "Changed language setting to 'us_english'." ) if ( $err != NULL ) { printf("<tr><th>Error Message</th></tr>\n"); printf("<tr><td>%s</td></tr>\n",sybase_get_last_message()); } print("</table>"); sybase_close(); ?> -- Edit bug report at http://bugs.php.net/?id=19841&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=19841&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=19841&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=19841&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=19841&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=19841&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=19841&r=support Expected behavior: http://bugs.php.net/fix.php?id=19841&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=19841&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=19841&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=19841&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=19841&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=19841&r=dst IIS Stability: http://bugs.php.net/fix.php?id=19841&r=isapi