[Tickets #6198] Re: One loop less

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://dev.horde.org/horde/whups/ticket/?id=6198
-----------------------------------------------------------------------
 Ticket             | 6198
 Updated By         | Michael Rubinsky <mrubinsk at horde.org>
 Summary            | One loop less
 Queue              | Ansel
 Type               | Enhancement
 State              | Resolved
 Priority           | 1. Low
 Milestone          | 
 Patch              | 
 Owners             | Michael Rubinsky
-----------------------------------------------------------------------


Michael Rubinsky <mrubinsk at horde.org> (2008-02-04 15:43) wrote:

>> I understand using the sql alias in the select statement, but why
>> would we need to rename the table columns to do this?
>
> Aliasing something as desc or default will result in a  sql sintax 
> error as DESC and DEFAULT are reserved words.

Cool. I sure am getting a lesson in SQL today :)

Thanks. I'm gonna create this as another ticket and do the changes after
every thing else I'm in the middle of settles down...

Thanks again!