Blank Form Fields and Updating DB
Posted: Sun Dec 13, 2009 5:32 pm
Hi,
I have a form for updating records that correspond to a given ID. My SQL query is set to update all the fields corresponding to the ID based on values entered on the update form. However, if some of the fields are left blank, the record is updated with these blank fields. I only want to update the fields that have text in them because those are fields the user wishes to modify. How can I address this?
Thank you
I have a form for updating records that correspond to a given ID. My SQL query is set to update all the fields corresponding to the ID based on values entered on the update form. However, if some of the fields are left blank, the record is updated with these blank fields. I only want to update the fields that have text in them because those are fields the user wishes to modify. How can I address this?
Thank you