[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


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:ayounis
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

649 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