@MGK: Thanks. Good suggestion, but sadly doesn't win the prize. That
gives the same result.
Cheers
Mike Kear
On Tue, Jun 8, 2010 at 3:23 PM, m...@ampersand.net.au
<m...@ampersand.net.au>wrote:
> 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 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.
>
> --
> 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<cfaussie%2bunsubscr...@googlegroups.com>
> .
> For more options, visit this group at
> http://groups.google.com/group/cfaussie?hl=en.
>
--
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
--
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.
