databases

[ewan brown]

hello
I have a working database from which i can extract values etc, I now want to update some values.
I think i have the correct sql syntax, but get the errror saying no resultSet produced, do i want a resultSet if i'm just updating a table?

thanks

[dlorde]

If you're just updating a table, you won't get a ResultSet, but you usually get the updated row count. For SQL statements that return an integer row count (or nothing), you should use executeUpdate() with a Statement or PreparedStatement.

Without seeing the code, I can't be more specific about your error.

Dave

To email me remove '_spamjam' from my email address