When I use a pure PHP to MSSQL connection and perform a SQL query as follows:
Code: Select all
SELECT contact_detail.contact_detail_type_id AS 'contact_detail.contact_detail_type_id' FROM db.dbo.contact_detailCode: Select all
array(1) { ["contact_detail.contact_detail_"]=> string(1) "2" }I am using the following:
Microsoft SQL Server 2005
Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600
PHP Version 5.1.1
Apache Version Apache/2.2.0 (Win32) DAV/2 mod_ssl/2.2.0 OpenSSL/0.9.8a mod_autoindex_color PHP/5.1.1
Its probably a small setting somewhere, thanks