Form field changes

[momo]

Hi,

I have a page that contain almost 70 textboxes, dropdown boxes and
checkboxes. This page retrieves data from a table and display them in the
appropriate control. My dilemma is when I need to make a change to any of
the control. I want to be able to update the table fields with the ones that
has a value. I created an update SQL statement that had all the fields but
it bombs out when on of the controls does not have anything in it. How do I
go about making this work.

 

[Jeff Dillon]

Define "bombs out". Do you get a specific error message? Do these database
fields allow nulls?

If the user is supposed to fill all of them out, then you need to check that
and let them know, before trying to save. This can be done either clientside
or serverside.

Jeff