ID: 35037 Updated by: [EMAIL PROTECTED] Reported By: spooky at int13h dot com -Status: Assigned +Status: Closed Bug Type: MSSQL related Operating System: FreeBSD 5.4 PHP Version: 5CVS-2005-10-31 (snap) Assigned To: fmk New Comment:
This bug has been fixed in CVS. Snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at http://snaps.php.net/. Thank you for the report, and for helping us make PHP better. Previous Comments: ------------------------------------------------------------------------ [2005-11-01 11:38:06] [EMAIL PROTECTED] Frank, can you check this out please? ------------------------------------------------------------------------ [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