Mike, I sent out another email with a link to an article about changing the database collation.
Steve -----Original Message----- From: Mike Kear [mailto:[email protected]] Sent: Wednesday, May 12, 2010 10:10 AM To: cf-talk Subject: Re: SQLServer2005 and European dates Thank you Steve, but I dont think you've seen the point. The query you wrote isnt the one I'm using. you wrote: Select * >From someTable Where myDate >= '05-01-2010' And myDate < dateAdd(m, 1, '05-01-2010'); and that gets all the May results. We're sending: Select * >From someTable Where myDate >= '01-05-2010' And myDate < '31-05-2010'; and it gets NO May results. As i said, re-writing hundreds of queries throughout the application is NOT an option. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333602 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
