[freetds] AS clause in 8.0
rsyring at gmail.com
Fri Mar 23 15:55:44 EDT 2012
Instructions on creating a TDS trace:
Development& Executive Director
Level 12 Technologies <https://www.lev12.com/>
Principled People, Technology that Works
On 03/23/2012 03:17 PM, Krzysztof Chodak wrote:
> Again - check your tds trace. Maybe PHP is somehow rewriting
> (sanitizing) the query on the fly?
> On Fri, Mar 23, 2012 at 20:15, Richard Stevens<bitwizard at skybest.com> wrote:
>> 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?
>> 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?
>> FreeTDS mailing list
>> FreeTDS at lists.ibiblio.org
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
More information about the FreeTDS