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