Sybase CALL statement problems

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



When retrieving ODBC results from Sybase SQL Anywhere 6 and 9 from a
CALLed procedure, the output to the browser is being arbitrarily
truncated. 

<?php 
$DataSourceUserID = "user";
$DataSourcePassword = "pass";
$DataSourceName = "source";

$ODBCConnect =
odbc_connect($DataSourceName,$DataSourceUserID,$DataSourcePassword);
$CallSQL = "CALL mladselmeans( '', 0, 9999, 0, 99999999, 0, 99999999,
'mladsite', 1 )";
$CallTest = odbc_exec( $ODBCConnect, $CallSQL );
odbc_result_all($CallTest);
?>

The resulting output does contain proper data, but as I said, it
simply gets chopped off at a seemingly random point (I have had it
chop anywhere from 1500-25000 characters off).  The amount of
truncation seems to vary depending on the results of the CALL, and
when the results are the same, the truncation is the same.  Perhaps
the strangest thing is that I know for a fact that all of the data is
being returned by Sybase... If I use output buffering and send the
contents of the buffer to a file before the end of the script, all of
the data makes it into the file, but still not to the browser. 
Trying to free the odbc resource or close the connection results in
no output at all.

ANY thoughts on this matter would be appreciated.

Anthony Robins
Using PHP 4.3.4 on Windows 2000 Server. 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux