Technote Details :: Column cannot be null

When submitting data into a database table, through a form, I get an error message,saying "General (or SQL) error: Column 'name' cannot be null".

For ASP_VBScript server model, the error is similar:

• Operating System: All.
• Server Models: All.
• Dreamweaver version: MX, MX 2004.

This usually happens because a form field is left empty. One of the table columns used in the insert operation does not allow NULL values, which causes the insert to fail. The table column does not allow null values based on settings from the database software.

There are several solutions to this issue:

1. If the column specified in the error message is not that important and could contain NULL values, alter the table structure and the column properties to allow NULL values. Instructions on how to do it should be provided with your database management software.
2. Make sure to always enter a value in the corresponding form field or use Form Validation to check for a value before executing the SQL query.
3. Set a default value for the form field, either through the wizard (Insert Record Wizard, Update Record Wizard or the NeXTensio Form Wizard) or by editing the corresponding server behavior.