Re: How can I default blanks to a string column

[James Harrill]

James Harrill wrote:
> Hello,
>
> I need string fields to default to blanks when the
> user does not enter any data in a form for
> non-required fields, or for fields in the table
> that are not on the form to begin with.
>
> First I defined these columns as NOT NULL,
> thinking that if no data was entered, the word
> NULL would NOT be defaulted, but instead it would
> defaul to blank. However, when I tested my form, I
> got errors for trying to insert a record without
> having data in the NOT NULL columns. So I changed
> my table by unchecking NOT NULL in MySQL
> Administrator. When I insert a record now, the
> columns have "NULL" in them. I need blanks.
>
> I am using Dreamweaver MX 2004, PHP, MySQL, and
> also third party extension software called MX
> Kommerce from InterAKTonline.com
>
> Thanks