Dates & NULL values

[vario]

I am puzzling over a couple of things...

1) I load external data to a table via mysqlimport and assign a php uniqid. Any null valued columns correspdonding to a readonly field on the edit screen will be set to '' if I edit the row, columns that aren't readonly remain null. Can I get a readonly field to remain null?

2) When I insert a data via the edit screen, a blank field corresponding to a column with DATE format will have '0000-00-00' while a VARCHAR will have the string 'NULL'. Can I get nuBuilder to insert a null value to a date column?

I am using nuBuilder version 11.11.03.

[admin]

vario,

In the structure of your table are your fields set to NULL or NOT NULL?

Steven

[vario]

Steven,

These columns are set NULL.

[johnbertell]

I can't find any response to this post. I have the same problem. I have some fields in my form that I would like to pass back to the database as NULL if they have not been changed or left empty in the form, but the nuBuilder form continues to convert them, dates to '0000-00-00' and dropdown fields to ''.

[massiws]

johnbertell, I think nuBuilder can't manage NULL values.
Have a look at this post.

Max