My form works properly if all the fields in it are filled but it gives me an error 'Error in row'.How can I pass some value in an empty field.<BR><BR>thanks,<BR>Dave
Do your database fields allow zero length?<BR><BR>You can test each form box and then make it blank if its null:<BR><BR>dim field<BR>field = request.form("field")<BR><BR>if field = "" then<BR>field = " "<BR>end if<BR>
Thanks Erica. I changed the settings of my fields to 'allow zero length'=Yes and it worked. once again thanks for your help..