From: [EMAIL PROTECTED]
Operating system: Linux 2.4.2-2smp Redhat7.1
PHP version: 4.1.1
PHP Bug Type: MSSQL related
Bug description: printing of mssql 'bit' value crashes script
outputing a bit field via print, echo, or var_dump causes the process to go
defunct.
--setup info
Apache/1.3.14 Ben-SSL/1.42
php 4.1.1
./configure --with-apxs=/usr/local/apache/bin/apxs --with-xml --enable-ftp
--with-sybase=/usr/local/freetds --with-openssl=/usr/local/ssl
--with-curl
freetds-0.51
mssql server 7.0
Here is an example
-------------------------------------------
$bit_result = mssql_query('SELECT some_bit_field FROM fake_table');
$bit_row = mssql_fetch_array($bit_result);
print $bit_row['some_bit_field'];
-------------------------------------------
--script crashes and the apache process goes defunct
-------------------------------------------
This SQL cast fixes it....
-------------------------------------------
$bit_result = mssql_query('SELECT Cast(some_bit_field AS varchar(2)) AS
some_bit_field FROM fake_table');
$bit_row = mssql_fetch_array($bit_result);
print $bit_row['some_bit_field'];
-------------------------------------------
-------------------------------------------
The actual script that led me to discover this problem was sigificantly
longer and I was able to use the value as long as I never ouput it (I
think the reslts of comparisons I made were false though. i.e. if (
$bit_row['some_bit_field'] == 1 ) {} ). The point is that you can include
the value in the expression but never ouput it.
--
Edit bug report at: http://bugs.php.net/?id=15265&edit=1
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
