I did not specify when creating the table that it could be NULL, as I thought this was the default if you did not put NOT NULL...Am I wrong?
Would this take care of the whole issue? ________________________________________ From: Greg Morphis [[email protected]] Sent: Saturday, September 24, 2011 10:06 AM To: cf-newbie Subject: Re: Handling default date in CF-->SQL I would just allow NULLs.. dealing with dummy dates is reallya bad deal.. I'm working with a website 14 years old and the dummy dates are 1/1/1900 and sometimes 1/1/2000.. since the website expands the 2000 date range there's trouble.. so just allow NULLs On Sat, Sep 24, 2011 at 9:01 AM, Martin, Donna M <[email protected]> wrote: > > Good morning, all, > > > > I am trying to deal with date fields on a payment form when either of them > remain empty on add/edit. SQL kindly enters a default value of 30 Dec 1999 > for me, which is fine. But of course, I don't want to show that date when > editing the record. > > > > I can always do a cfif and not display when it is 12/30/1999, but is this > really how I have to do it? That seems really awkward. Not that it would > be in this case, but what if the date really WAS 12/30/1999? What then? > > > > How do you guys handle it? I am feeling rather ignorant at the moment, and > would appreciate some direction. > > > > Thanks much! > > Donna > > > > > > ________________________________ > > This e-mail message (including any attachments) is for the sole use of > the intended recipient(s) and may contain confidential and privileged > information. If the reader of this message is not the intended > recipient, you are hereby notified that any dissemination, distribution > or copying of this message (including any attachments) is strictly > prohibited. > > If you have received this message in error, please contact > the sender by reply e-mail message and destroy all copies of the > original message (including attachments). > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5616 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
