Re: [cfaussie] Odd date behaviour - CF9/SQLServer2005

[m...@ampersand.net.au]

How about CF_SQL_TIMESTAMP instead? On 8/06/2010 3:16 PM, Mike Kear wrote: @Dale,  I've just done a complete 180degree on that.   Yes i think it is coldfusion that's doing it.  I did a few more inserts and looked at the debugging. The variable that the insert is being given is a date that is definitely 10 May 2010.  I can CFDUMP it using formatting that shows that it knows that the month is 05.   Then when i look at the variables in the insert statement,  when i use the CFQUERYPARAM type=cf_sql_date  its inserting {ts '2010-10-05 00:00:00'} I get the same when i use #createodbcdate(   )# instead of the CFQUERYPARAM tag. So in Application.cfc,  in onApplicationStart() I put setLocale( en_AU ) and that made no difference.   AAARRGH!!!!!!! I get the same result on both my dev machine here in my ofi and the remote production server. Does anyone have any other suggestions as to where i might look? 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 On Tue, Jun 8, 2010 at 3:00 PM, Dale Fraser <d...@fraser.id.au> wrote: Mike,   I find it hard to believe it is SQL Server, this smacks of ColdFusion its the exact type of behaviour that ColdFusion does.   Hard to believe that SQL Server would modify an ODBC date due to a localisation setting.   I would still try to duplicate the problem with your own code, can you write code that will put it in the database wrong.   createODBCDate(createDate(year, month day))   I but you can’t make that put a wrong date in unless you get the month and day back to front   Regards Dale Fraser   http://dale.fraser.id.au http://cfmldocs.com http://learncf.com http://flexcf.com   -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.