<div>
<div class="content wysiwyg-content">
Hi All,<br />
&nbsp;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.<br />
<br />
My SQL statement is simple:<br />
&quot;SELECT * from NavTable&quot;<br />
<br />
Unfortunately, the recordset does not return the rows in the same order. &nbsp;<br />
<br />
Everything is re-arranged. <br />
<br />
What can I do?<br />
TIA DoughBoy<br />

</div>
</div>


Hi All,
 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?
TIA DoughBoy


JDBC select all rows in order

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.