Insert NULL or "" into DB
Posted on 2004-09-28
2 fields are not mandatory so I want to give the user to leave them blank, but when I do an update I get an Error.
/mm/MM_stage2/departments/updatedepartmentData.asp, line 110
This is to do with the datatypes used in the DB for these to feilds.
field 1 = INT 4
field 2 = Decimal 8
I have 'Allow nulls' ticked as well
If I set these fields to 'varchar' then it works fine but I do not want these fields to be varchar for when I use them later.
I want these to be blank if the user does not enter any values in these but do not know how to do it!