rotflmao Anyway, your problem is going to depend on you. Personally I know that my SQL 20008 SR2 stores the date as 1900-01-01, so I have a service (a usable query) that pulls the data in, checks the year is 1900 if it is then returns null as part of the query.
-- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Sun, Sep 25, 2011 at 1:21 AM, Martin, Donna M <[email protected]> wrote: > > 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:5621 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
