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.
Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
Dates & NULL values
-
- Posts: 122
- Joined: Mon Dec 05, 2011 12:23 pm
- nuBuilder Version: 4.5
- Location: Newton Abbot, UK
-
- Site Admin
- Posts: 2781
- Joined: Mon Jun 15, 2009 2:23 am
- nuBuilder Version: 4.5
- Been thanked: 1 time
Re: Dates & NULL values
vario,
In the structure of your table are your fields set to NULL or NOT NULL?
Steven
In the structure of your table are your fields set to NULL or NOT NULL?
Steven
-
- Posts: 122
- Joined: Mon Dec 05, 2011 12:23 pm
- nuBuilder Version: 4.5
- Location: Newton Abbot, UK
-
- Posts: 14
- Joined: Thu Oct 24, 2013 6:32 am
Re: Dates & NULL values
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 ''.
-
- Posts: 503
- Joined: Thu May 24, 2012 2:08 am
- Location: Milan, Italy
- Contact: