I also have SQL 2008 with CF 8. HTH D
________________________________________ From: Andrew Scott [[email protected]] Sent: Saturday, September 24, 2011 10:09 AM To: cf-newbie Subject: Re: Handling default date in CF-->SQL What version of SQL Server and what version of ColdFusion? I have SQL 2008 which defaults to 01/01/1900, so what you could is check to see if it is empty and set the date to this so that a date is being stored. Or you can change the database itself to set the default to this value. The choice is what you are going to be comfortable with. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Sun, Sep 25, 2011 at 12: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:5615 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
