i understood what you want, your basically writing a update statement and in this statement your putting all the column names whether its empty or with data and setting the data to update based on what was entered on the webpage.

to allow an empty field to update as empty make sure that column or field doesnt have the not null selected so that you will be able to update it witout data.

im thinking that you used the update or insert statement and had set the column to not null and that when you tried to insert or update you were getting errors.

__________________
no signature set