How can I allow blank fields in a Dynamic form?

Posted on 2004-10-21
Medium Priority
Last Modified: 2010-05-18
I currently have a record insertion form which connects to my MySQL database on a remote server.

The fields and columns are viewable in this insertion form. I have selected them to display mostly as text fields and also as menu items. So far so good.

During testing, I have noticed that if some of the fields in the form are left blank when the form is submitted - I am rediredted to a blank white page with the message Column '(column name)' cannot be null.

I wish to allow some columns to be blank. Is there a way to do this?


Question by:Adam
1 Comment

Accepted Solution

bitter_chicken earned 2000 total points
ID: 12378533
Hi ayounis

This is not a problem with dreamweaver - this is a setting you must change in the MySQL database

When you create the table, defining NOT NULL will mean that the database will chuck an error if you try to put nothing in the field.

If you are using phpMyAdmin or something similar, you will see a drop-down box with "NULL" or "NOT NULL" as options (when creating or editing a table). Set this to "NULL" and it will allow NULL as a value (i.e. no value)

If you need specific help changing this property in your table, please give specific info about what system you are using.

bc :-)

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
This article is very specific and is only intended to help if you are installing Dreamweaver 8 in a Windows 7 environment with Office 2007 installed.   I'm not sure why Microsoft tends to release OS' that should not be released but they do.  Windows…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question