Re: MSSQL Server 2005 - select [field] AS [name] does not work?

"James K. Lowden" <[email protected]> Tue, 15 May 2012 10:27:10 -0400

Newsgroups	gmane.comp.db.tds.freetds
Message-ID	<[email protected]>

On Tue, 15 May 2012 10:56:42 +0000
Neil Whitaker <[email protected]> wrote:

> You can see it should be [The_Key] => 1
> 
> It's reproducible - and I have access to two servers (one with
> FreeTDS 0.82, the other with 0.91) - both exhibit this behaviour.

If you get the correct answer to the same query with isql or bsqlodbc,
you might want to report the problem to the PHP project.  IIRC this has
been reported before and owes to PHP using the wrong property for the
column name.  

--jkl