freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

From: "James K. Lowden" <jklowden AT freetds.org>
To: freetds AT lists.ibiblio.org
Subject: Re: [freetds] MSSQL Server 2005 - select [field] AS [name] does not work?
Date: Tue, 15 May 2012 10:27:10 -0400

On Tue, 15 May 2012 10:56:42 +0000
Neil Whitaker <NWhitaker AT acornstairlifts.com> 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

[freetds] MSSQL Server 2005 - select [field] AS [name] does not work?, neil AT hencam.co.uk, 05/15/2012
- <Possible follow-up(s)>
- [freetds] MSSQL Server 2005 - select [field] AS [name] does not work?, Neil Whitaker, 05/15/2012
  - Re: [freetds] MSSQL Server 2005 - select [field] AS [name] does not work?, James K. Lowden, 05/15/2012
    - Re: [freetds] MSSQL Server 2005 - select [field] AS [name] does not work?, Neil Whitaker, 05/15/2012
      - Re: [freetds] MSSQL Server 2005 - select [field] AS [name] does not work?, James K. Lowden, 05/15/2012