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
