I would like to collect all the rows of a small MS Access database in the order that they are listed in the database. I am using JDBC in JSP pages.
My SQL statement is simple:
"SELECT * from NavTable"
Unfortunately, the recordset does not return the rows in the same order.
Everything is re-arranged.
What can I do?