@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 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.