Thread: Using executeUpdate Question

I have an html page that allows me to enter some address values. These
values get passed to a servlet which uses executeUpdate to try and update several columns in a microsoft access database. The problem that I am having is that if I enter 2 values from the Htlm page which gets passed to the servlet to update two columns the other colunns in the database also get wiped out which is not what I want. I just need to update 2 values and leave the remaining colums in the database untouched. The update code is below.


r_updcnt = s.executeUpdate("update AddressInfo2 SET F_NAME='" +
fname + "', L_NAME='" + lname + "', STREET_ADDRESS='" + addr + "' WHERE F_NAME='"+sfield+"'");

copeg, thanks for the info that you mentioned using an update starement that updates 2 columns. But if I have 10 columns on the html page and they want to update 5 of the 10 columns one time nad the another time they want to update 3 different columns of the 10 then would i need to set up different updates one for each different set of conditions?.

copeg, I will try that..

Thanks