ID: 35037 Updated by: [EMAIL PROTECTED] Reported By: spooky at int13h dot com -Status: Open +Status: Assigned Bug Type: MSSQL related Operating System: FreeBSD 5.4 PHP Version: 5CVS-2005-10-31 (snap) -Assigned To: +Assigned To: fmk New Comment:
Frank, can you check this out please? Previous Comments: ------------------------------------------------------------------------ [2005-10-31 18:11:49] spooky at int13h dot com 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 this bug report at http://bugs.php.net/?id=35037&edit=1