#35037 [NEW]: unknown data type (36)
From: spooky at int13h dot com
Operating system: FreeBSD 5.4
PHP version: 5CVS-2005-10-31 (snap)
PHP Bug Type: MSSQL related
Bug description: unknown data type (36)
Description:
------------
For php5-200510311530 (Also 5.0.5 stable release)
./configure --prefix=/usr/local --with-apxs=/usr/local/apache/bin/apxs
--with-libxml-dir=/usr/local
--with-zlib
--with-curl
--with-gd
--with-ldap
--with-mssql
--with-pear
For FreeTDS 0.63
./configure --prefix=/usr/local
--with-tdsver=8.0
--enable-msdblib
When I fire an SQL Query that returns a uniqueidentifier I get the error
'Warning: mssql_query() [function.mssql-query]: column 1 has unknown data
type (36) in /usr/websites/dev/testies.php on line 12'
Reproduce code:
---------------
function connect_sql ()
{
$mssql_link = mssql_connect('<IP>',
'<USER>','<PASSWORD>') or die
("Server Connection Error");
$mssql_db = mssql_select_db('Websites',$mssql_link) or die("Database
Error");
}
connect_sql();
$query = 'select newid() as test';
echo $query . '<br/>';
mssql_query($query);
mssql_close();
Expected result:
----------------
No result should be returned. It should generate a new id.
Actual result:
--------------
'Warning: mssql_query() [function.mssql-query]: column 1 has unknown data
type (36) in /usr/websites/dev/testies.php on line 12'
--
Edit bug report at http://bugs.php.net/?id=35037&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=35037&r=trysnapshot4
Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=35037&r=trysnapshot50
Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=35037&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=35037&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=35037&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=35037&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=35037&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=35037&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=35037&r=support
Expected behavior: http://bugs.php.net/fix.php?id=35037&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=35037&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=35037&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=35037&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=35037&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=35037&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=35037&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=35037&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=35037&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=35037&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=35037&r=mysqlcfg
Thread (3 messages)
- spooky at int13h dot com