Package: php5-odbc
Version: PHP 5.2.6-1+lenny8
I am experiencing the same issue when querying tables on a SQL Server 9.0.4053
(SQL Server 2005).
SELECT ID, Column AS alias FROM Table;
Returns:
ID | Column
---
1 | value
2 | value
3 | value
Instead of:
ID | alias
---
> Write it without and it will work.
Whitespace does not make a difference (I have tested it just to be sure).
With php-odbc v5.2.6, I have confirmed this bug affects queries to MS
SQL Server 2000. The same query to a MySQL 5 works fine.
On a positive note, I have noticed that this issue is fi
Am 2008-10-14 10:35:14, schrieb Eric Meygret:
> Package: php5-odbc
> Version: 5.2.5-3+lenny2
>
> When I use AS keyword in a select, the alias don't work in result.
>
> for exemple
> when I do "select firstname, lastname as name from person"
^^^
Write it wit
Package: php5-odbc
Version: 5.2.5-3+lenny2
When I use AS keyword in a select, the alias don't work in result.
for exemple
when I do "select firstname, lastname as name from person"
odbc_result_all give :
*firstname* *lastname *
instead of **
*firstname* *name*
yy
4 matches
Mail list logo