This week's book giveaways are in the Refactoring and Agile forums. We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line! See this thread and this one for details.
I am trying to navigate thru large number of records. I am having problem with the move-to-next record process. I have a recordid field (unique) but our client requires that records be sorted by their description. Example, I am currently in recordid 5, when i click on the next button, the next record that will appear may or may not be recordid 6. How will I implement an accurate navigation if my reference id will not be the record id? Any suggestions? Please help!
posted 12 years ago
use the 'ORDER BY description' in your SQL statement. The ResultSet represents the order of the SQL query.