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 2004/02/11 17:41:27 UTC

DO NOT REPLY [Bug 26863] New: - error in ResultSetTag if ResultSet is empty

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

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=26863

error in ResultSetTag if ResultSet is empty

           Summary: error in ResultSetTag if ResultSet is empty
           Product: Taglibs
           Version: 1.0B1
          Platform: PC
        OS/Version: Other
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: DBTags Taglib
        AssignedTo: taglibs-dev@jakarta.apache.org
        ReportedBy: ttor@ukr.net


I create ResultSet object in servlet and save it in requests scope:
PreparedStatement pstmt;
...
ResultSet searchResults = pstmt.executeQuery();
request.setAttribute("searchResults", searchResults);
Then in jsp:
<sql:resultSet id="rs1" name="searchResults" scope="request">
<sql:getColumn colName="name"/><br>
</sql:resultSet>

It works fine, if searchResults has any records. If searchResults is empty, 
then once again will be output the result from the previous call to 
<sql:resultSet>. 

I have already made changes in my local copy of ResultSetTag.java to fix this 
problem and it works. If you interested, I can mail you my changes.

Good luck.

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