The problem I am having is substituting the value in the update statement to that of the variable the is supplied in the parenthesis or even the set up within the method e.g.
int zxc=9;
I have tried all variations I can think of enclosing the variable escape \\ “ “ etc none of which work
When using
String query = "update books set quantity ='\"zxc\"' where isbn13 =" + isbn;
I get the following error report
java.sql.SQLException: Incorrect integer value: '"zxc"' for column 'quantity' at row 55492
the column in the books table is set to integer and is 10 wide and the values produced in the app numbers 0 through 40 only so should be sufficient
any ideal where the problem lies