Re: AS clause in 8.0

Thank you, Ken, for such a quick reply.
I just discovered that this behavior ONLY occurs when querying through PHP5.
The same query run from isql (unixODBC's utility) returns the correct 
column name.
Perhaps I should be posting this in a PHP forum - unless someone has 
seen this before and figured out the solution?

-Richard

On 03/23/2012 02:30 PM, Ken Collins wrote:
> I can verify that this is not the case with both FreeTDS 0.82 or 0.91 using either TDS Version 7.0 or 8.0 with DBLIB.
>
>   - Ken
>
> On Mar 23, 2012, at 1:46 PM, Richard Stevens wrote:
>
>> I am having a (big) problem with FreeTDS 8.0 that I did not have with 7.0.
>> The "AS" clause does not work correctly.
>> By example, "select apples as oranges from table"  will return a column
>> named oranges in 7.0, but returns a column named apples in 8.0.
>> Everything else is the same - same machine, OS, etc.  Just changing the
>> "tds version = 8.0" in freetds.conf causes the behavior.
>>
>> Anyone have ideas on a solution?
>>
>> Thanks,
>> Richard
>