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 1 year ago
Thanks Paul..that did it
Straws are for suckers. Now suck on this tiny ad!
Devious Experiments for a Truly Passive Greenhouse!