before opening the popup, i am trying to say a user message if there are no records returned.. ----- 1. if (rs==null) doesn't seems to catch a empty resultset returned) 2. if rs.next() is used it is skipping to display one record in the popup. how to get around this , i am hoping i don't have to make an extra database call or use another type of cursor
Well, I don't KNOW but since no one else is taking a shot at this... I found this in the API for the ResultSet interface "The number, types and properties of a ResultSet object's columns are provided by the ResulSetMetaData object returned by the ResultSet.getMetaData method." And the ResulSetMetaData interface has a method getColumnCount(). I'd try that.