freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: Randy Syring <rsyring AT gmail.com>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Cc: bitwizard AT skybest.com
- Subject: Re: [freetds] AS clause in 8.0
- Date: Fri, 23 Mar 2012 15:55:44 -0400
Instructions on creating a TDS trace:
http://www.freetds.org/userguide/logging.htm
---------------------------------------------
Randy Syring
Development& Executive Director
Level 12 Technologies <https://www.lev12.com/>
Direct: 502-276-0459
Office: 502-212-9913
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?
-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
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
-
[freetds] AS clause in 8.0,
Richard Stevens, 03/23/2012
-
Re: [freetds] AS clause in 8.0,
Ken Collins, 03/23/2012
- Re: [freetds] AS clause in 8.0, Krzysztof Chodak, 03/23/2012
-
Re: [freetds] AS clause in 8.0,
Richard Stevens, 03/23/2012
-
Re: [freetds] AS clause in 8.0,
Krzysztof Chodak, 03/23/2012
- Re: [freetds] AS clause in 8.0, Randy Syring, 03/23/2012
-
Re: [freetds] AS clause in 8.0,
Richard Stevens, 03/27/2012
- Re: [freetds] AS clause in 8.0, James K. Lowden, 03/27/2012
-
Re: [freetds] AS clause in 8.0,
Krzysztof Chodak, 03/23/2012
-
Re: [freetds] AS clause in 8.0,
Ken Collins, 03/23/2012
Archive powered by MHonArc 2.6.24.