You are viewing a plain text version of this content. The canonical link for it is here.
Posted to taglibs-dev@jakarta.apache.org by bu...@apache.org on 2005/01/11 23:33:53 UTC

DO NOT REPLY [Bug 33054] New: - sql:query loses query column order

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=33054>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=33054

           Summary: sql:query loses query column order
           Product: Taglibs
           Version: 1.0.6
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: enhancement
          Priority: P5
         Component: Standard Taglib
        AssignedTo: taglibs-dev@jakarta.apache.org
        ReportedBy: joachimm@yahoo.com


sql:query appears to be using a TreeMap to hold row data.  This means
that it cannot be used to execute and display dynamic (user supplied)
SQL, because the column order is incorrect.

Please consider using SequencedHashMap from Jakarta commons-collections,
which will preserve entry order in the map.  I realize this will introduce
some backward compatibility issues for some people, but they probably
should be using the Map interface anyway.

FYI, http://displaytag.sourceforge.net/ does a great job displaying
the output of sql:query, but since the columns are not in the right
order, it's not very helpful.

This is in:
http://cvs.apache.org/viewcvs.cgi/jakarta-taglibs/standard/src/org/apache/taglibs/standard/tag/common/sql/ResultImpl.java?rev=1.10&view=auto

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: taglibs-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-dev-help@jakarta.apache.org