Re: AS clause in 8.0
Randy Syring <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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<[email protected]> 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 >> [email protected] >> http://lists.ibiblio.org/mailman/listinfo/freetds > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds