Problem with delete

[faiyth]

I'll try and give as much information as I can for this.. maybe then you can help me?

Request.getParameter is a number. Even when I hard code a number in, the same error is given. This is a javaserver page. The user DOES have permission to delete. The database was connected with db.connect earlier in the program. If you need more information to help me solve this, then just state what you need and I'll try and provide it.

This is the delete statement
String query = "Delete from K9Manager where intakeno = ?";
PreparedStatement pstmt = db.createPreparedStatement(query);
pstmt.setInt( 1, Integer.parseInt(request.getParameter("ID&quot));
pstmt.executeUpdate();

This is the error:
Unable to query K9Manager table
java.sql.SQLException: [TDS Driver]No current row

 

[idarke]

You posted this five days ago, so you've probably solved it by now. If so, what was the problem?

If not, I have a question. "No current row" implies that there's a ResultSet being processed on the connection somewhere. What else is going on in that servlet?