[Resolved] Invalid Cursor State error...

[crptcblade]

I posted this in the Database forum, but I feel that I might get a response here as well.

I am trying to get a ResultSet from a database, and I keep getting this SQLException..."Invaid Cursor State". Now, I know that several things could cause this, but what could those things be? I am using almost identical code on a different servlet, and am not getting any errors...

//...
Statement stmt = conn.createStatement() //connection created earlier in the code
ResultSet rs      = stmt.executeQuery("SELECT * FROM Products WHERE ISBN='" + ISBN + '"); //exception is thrown here
//...

any thoughts?

[crptcblade]

Nobody? Help!!!

[VirtuallyVB]

Do you mean a runtime exception or a compile time error? I don't see a semicolon after the first statement.

Or maybe you need
ISBN='" + ISBN + "'");
with the tick mark between two quotes on the end.

ISBN= 1tick endQuote + ISBN + openQuote 1tick closeQuote);

[crptcblade]

I keep forgetting to update my threads. I fixed it, but I can't figure out why it didn't work. Oh, well, as long as it works now, I guess.

Thanks