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)
signature.pgp
Description: Digital signature