[php-maint] Bug#502174: select AS with php5-odbc

Michelle Konzack linux4michelle at tamay-dogan.net
Wed Oct 15 01:30:51 UTC 2008


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 without <SPACE> and it will work.

Also for better readability I suggest to use:

    SELECT firstname,lastname AS name FROM person;

Thanks, Greetings and nice Day/Evening
    Michelle Konzack
    Systemadministrator
    24V Electronic Engineer
    Tamay Dogan Network
    Debian GNU/Linux Consultant


-- 
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack   Apt. 917                  ICQ #328449886
+49/177/9351947    50, rue de Soultz         MSN LinuxMichi
+33/6/61925193     67100 Strasbourg/France   IRC #Debian (irc.icq.com)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://lists.alioth.debian.org/pipermail/pkg-php-maint/attachments/20081015/fa8e7d28/attachment.pgp 


More information about the pkg-php-maint mailing list