Gossamer Forum
Home : Products : DBMan SQL : Discussion :

I want date to stay NULL, not turn into 0000-00-00

Quote Reply
I want date to stay NULL, not turn into 0000-00-00
There are some other threads in here about suppressing the _display_ of dates with values 0000-00-00. This is different: I have a record with a date column having a value of NULL (displayed as blank), yet it is modified to 0000-00-00 (and so displayed thereafter) when I touch any field in the record. I want this date to STAY NULL until the user enters a real date into the form. How can I do this?

This is DBManSQL 2.1.0 with MySQL 4.0.24. I do have a PlugIn that runs on modification, but it only notes what changed (and writes a separate Audit record); otherwise it falls through for the actual modifications.
Subject Author Views Date
Post I want date to stay NULL, not turn into 0000-00-00 jxh 2680 Aug 3, 2006, 4:35 PM