Dates & NULL values
Posted: Thu Feb 16, 2012 9:55 am
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.
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.