I'm going to guess that Search_ID is not a column in that database table, and "faltering" means the program crashes because of that error. More information on your problem would be extremely useful.
I see that you are using a PreparedStatement, which is a good first step. But guessing (again) that Search_ID is a variable in your code, or something like that, then the PreparedStatement would look something like this:
Then you would use ps.setInt() to fill in the question mark before executing the SQL.
Hope that helps -- if I'm on the wrong track then by all means help us by providing a full description of the problem.
posted 2 months ago
Thanks Paul..that did it
All of the world's problems can be solved in a garden - Geoff Lawton. Tiny ad:
RavenDB is an Open Source NoSQL Database that’s fully transactional (ACID) across your database