Oh, my bad...So VERY sorry. One of my best friends is named 'Scott' (first name, that is), and I think it was just habit. He's a nice guy, by the way.
Again, my apologies... Donna (or you can call me Martin (my last name), just to make it even) ________________________________________ From: Andrew Scott [[email protected]] Sent: Saturday, September 24, 2011 11:03 AM To: cf-newbie Subject: Re: Handling default date in CF-->SQL Seriously, How do people get my name wrong..... -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Sun, Sep 25, 2011 at 12:40 AM, Martin, Donna M <[email protected]> wrote: > > Hi Scott, > > I did not intervene--honest. But it is defaulting to 12/30/1999. I > suppose I can change this with a cfset. I imagine I can change this in the > SQL server settings, but have never looked to see if this is possible. > > I know NULL's are frowned upon. Would it be best practice to change the > date to the 1900 date, and just not display if <some date? > > D > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:5620 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
