Re: Prevent Cake 1.2 from auto inserting 0000-00-00 00:00:00 into input fields

2007-10-19 Thread McFadly
If you're using a particular version of phpmyadmin (i'm speculating on what you're using here) it will allow you to have a null field and still have a default value of '-00-00 00:00:00' in a datetime field. Make sure that default value didn't get left in there. I've had this happen. On Oct

Re: Prevent Cake 1.2 from auto inserting 0000-00-00 00:00:00 into input fields

2007-10-19 Thread RLR
Thanks for your reply Nate but the default value is defined as NULL e.g. `recurring_date` datetime default NULL, Any other suggestions? On Oct 19, 9:32 pm, nate <[EMAIL PROTECTED]> wrote: > Change the default value of the column to NULL. > > On Oct 19, 3:10 pm, RLR <[EMAIL PROTECTED]> wrote: >

Re: Prevent Cake 1.2 from auto inserting 0000-00-00 00:00:00 into input fields

2007-10-19 Thread nate
Change the default value of the column to NULL. On Oct 19, 3:10 pm, RLR <[EMAIL PROTECTED]> wrote: > I recently started using cakephp 1.2 branch. > > The problem I am having is that a date field in my app is always saved/ > reloaded with "-00-00 00:00:00". I would prefer to use a NULL > valu

Prevent Cake 1.2 from auto inserting 0000-00-00 00:00:00 into input fields

2007-10-19 Thread RLR
I recently started using cakephp 1.2 branch. The problem I am having is that a date field in my app is always saved/ reloaded with "-00-00 00:00:00". I would prefer to use a NULL value when no date has been entered. How can I change/fix this behavior? Thanks --~--~-~--~~--