6.0.0-beta1
9/24/25

[#6204] Use SQL 'AS' aliases to remove the need for substr() handling of attribute names.
Summary Use SQL 'AS' aliases to remove the need for substr() handling of attribute names.
Queue Ansel
Type Enhancement
State Resolved
Priority 1. Low
Owners mrubinsk (at) horde (dot) org
Requester mrubinsk (at) horde (dot) org
Created 02/04/2008 (6442 days ago)
Due
Updated 05/24/2008 (6332 days ago)
Assigned
Resolved 05/24/2008 (6332 days ago)
Milestone
Patch No

History
05/24/2008 06:01:16 PM Michael Rubinsky Comment #2
Assigned to Michael Rubinsky
State ⇒ Resolved
Reply to this comment
This is resolved/no longer an issue with the new sql share driver.
02/04/2008 08:48:16 PM Michael Rubinsky Comment #1
State ⇒ Accepted
Priority ⇒ 1. Low
Type ⇒ Enhancement
Summary ⇒ Use SQL 'AS' aliases to remove the need for substr() handling of attribute names.
Queue ⇒ Ansel
Reply to this comment
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.


Saved Queries