Skip to Content.
Sympa Menu

freetds - Re: [freetds] AS clause in 8.0

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Krzysztof Chodak <krzysztof.chodak AT gmail.com>
  • To: bitwizard AT skybest.com, FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] AS clause in 8.0
  • Date: Fri, 23 Mar 2012 20:17:21 +0100

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?
>
> -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
>>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds




Archive powered by MHonArc 2.6.24.

Top of Page