[Tickets #6204] Use SQL 'AS' aliases to remove the need for substr() handling of attribute names.

[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=6204
-----------------------------------------------------------------------
 Ticket             | 6204
 Created By         | Michael Rubinsky <mrubinsk at horde.org>
 Summary            | Use SQL 'AS' aliases to remove the need for substr() handling of
                    | attribute names.
 Queue              | Ansel
 Type               | Enhancement
 State              | Accepted
 Priority           | 1. Low
 Milestone          | 
 Patch              | 
 Owners             | 
-----------------------------------------------------------------------


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

>From Duck:

With a little renaming of table columns  to avoid SQL reserved words, the
parameters replace loop could be replaced also.
For example the gallery_desc becomes gallery_description and you can
select columns with  an "AS" sql alias inside he select statement. Thus
reducing the attribute selection to only one loop.