Forums Register Login

Error Setting parameters in a Update preparedstatments

+Pie Number of slices to send: Send
Hey guys I have been working on making a form that updates a Microsoft Access database and I cannot seem to figure out the root of this error I continue to receive.

My edit form upon loading displays the information for a selected item. There is a submit button that updates the database with all changes. I have been using preparedStatements to update my database and I have 8 parameters for my first command, however, only 3 of the parameters are recognized. I have checked the SQL statement repeatedly in Access and have determined that it is not the cause.

My code goes as follows:

preparedStatement contactUpdate = "Update tblContact Set FirstName = '?', LastName = '?', Suffix= '?', DOB = '?',Address = ?...(other inserts)... Where contactID = ?";

contactUpdate.setString(1,"Jimbo");
contactUpdate.setString(2,"Delacroix");
contactUpdate.setString(3,"III");
contactUpdate.setDate(4,Date);
//Error right here on the next line.
contactUpdate.setInt(5, 32);
contactUpdate.setString(6,"Jimbo");
contactUpdate.setString(7,"Jimbo");
contactUpdate.setString(8, 1);

contactUpdate.execute();

If you have any suggestions please let me know.

+Pie Number of slices to send: Send
Tom,
Welcome to JavaRanch!

I may be missing the obvious here, but what error message do you get?

Does it work if you hardcode "address = 1" instead of using the prepared statement? This will tell you if the error is in the SQL part or the prepared statement part. Which will help someone here give you more specific advice.
Catch Ernie! Catch the egg! And catch this tiny ad too:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 1063 times.
Similar Threads
database update techniques?
Application logic & servlets
problem insert with DB2
Date javascript drop downs dynamically filled with jsp
How to update a database using web forms
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 10:18:31.