Hi,
I am doing a very basic update and display on a Microsoft Access DB but keep getting the following error message:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid cursor state.
Here is the code which connects to the database and is meant to display specific data:
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/Tomcat/jakarta-tomcat-4.1.31/webapps/ROOT/MyDB.mdb","","");
java.sql.Statement statement = conn.createStatement();
ResultSet rs = statement.executeQuery("SELECT * FROM queryName");
int test;
test = rs.getInt("custorderno");
%>
<TD> <%= test %> </TD>
</TABLE>
<%
rs.close();
%>
<%
ResultSet columns = statement.executeQuery("SELECT * FROM orderdetails WHERE code = "+ test +")");
while(columns.next()) {
String code = columns.getString("Code");
String product = columns.getString("Product");
String price = columns.getString("Price"); %>
<TABLE>
<TR> <TD> <%= code %> </TD>
<TD> <%= product %> </TD>
<TD> <%= price %> </TD>
</TR>
<% }
columns.close();
%>
</TABLE>
<%
if (statement != null)
statement.close();
if (conn != null)
conn.close();
}
catch (Exception e) {out.print(e);}
%>
</BODY>
</HTML>
Any ideas?