[#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 Michael Rubinsky <mrubinsk (at) horde (dot) org>
Requester Michael Rubinsky <mrubinsk (at) horde (dot) org>
Created 02/04/2008 (152 days ago)
Due
Updated 05/24/2008 (42 days ago)
Assigned
Resolved 05/24/2008 (42 days ago)
Attachments
Milestone
Patch No

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