It's getting more mysterious too, Kym. I have been concentrating on one
table - looking at the data in that table and the inserts into that table,
and being frustrated that all the tricks and traps I've learned over more
than a decade programming ColdFusion dont seem to be working.
Just
Actually what happens if you replace the cfquery tags
with cfoutput - just in case there is something odd going on before the
insert even happens.
On 8/06/2010 3:50 PM, Kym Kovan wrote:
On
8/06/2010 15:16, Mike Kear wrote:
@Dale, I've just done a complete 180degree
on that. Yes i think
Kear [mailto:afpwebwo...@gmail.com]
Sent: Tuesday, 8 June 2010 4:01 PM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Odd date behaviour - CF9/SQLServer2005
It's getting more mysterious too, Kym. I have been concentrating on one
table - looking at the data in that table and the inserts
The problem is probably related to dates where the day could also be
interpreted as the month. From the symptoms you're describing, I would guess
that -mm-dd is the default but -dd-mm is used to somehow resolve
ambiguous dates.
Blair
On Tue, Jun 8, 2010 at 9:23 AM, Mike Kear
in what format is ECRTTotal.getdateentered() returning the date?
_
From: Mike Kear [mailto:afpwebwo...@gmail.com]
Sent: Tuesday, 8 June 2010 9:23 AM
To: cfaussie
Subject: [cfaussie] Odd date behaviour - CF9/SQLServer2005
I have a conundrum that's driving me crazy and frustrating my
SQL Server is not ODBC compliant?
--
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,
@Steve: the date is created by the following, so it should be a coldfusion
date object:
cfset thisdate = createdate( thisyear, thismonth, thisday ) /
cfset ECRTTotal.setdateentered( thisdate) /
@Blair, I think you're right - the difference is between dates less than
or equal to 12th
://dale.fraser.id.au
http://cfmldocs.com http://cfmldocs.com/
http://learncf.com
http://flexcf.com
From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf
Of Mike Kear
Sent: Tuesday, 8 June 2010 10:20 AM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Odd date behaviour - CF9
Of Kym Kovan
Sent: Tuesday, 8 June 2010 10:32 AM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Odd date behaviour - CF9/SQLServer2005
On 8/06/2010 09:23, Mike Kear wrote:
I have a conundrum that's driving me crazy and frustrating my client
too. We have an application where dates are being
I would say its a localisation issue on the server
_
From: Mike Kear [mailto:afpwebwo...@gmail.com]
Sent: Tuesday, 8 June 2010 10:20 AM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Odd date behaviour - CF9/SQLServer2005
@Steve: the date is created by the following, so
Still think it might be a localisation problem
_
From: Mike Kear [mailto:afpwebwo...@gmail.com]
Sent: Tuesday, 8 June 2010 12:18 PM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Odd date behaviour - CF9/SQLServer2005
@Kym: you make an excellent point.I normally look
be a localisation problem
--
*From:* Mike Kear [mailto:afpwebwo...@gmail.com]
*Sent:* Tuesday, 8 June 2010 12:18 PM
*To:* cfaussie@googlegroups.com
*Subject:* Re: [cfaussie] Odd date behaviour - CF9/SQLServer2005
@Kym: you make an excellent point.I normally look
@googlegroups.com
Subject: Re: [cfaussie] Odd date behaviour - CF9/SQLServer2005
@Kym: you make an excellent point.I normally look at data in a table by
running a query, so i'm looking at query results in Management Studio.So
i used the Open table and looked at the data that way, and still see
: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf
Of Mike Kear
Sent: Tuesday, 8 June 2010 12:28 PM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Odd date behaviour - CF9/SQLServer2005
@Steve Yes It might well be a localisation problem.The server is
sitting
@Dale, I would have said that too. My first assumption was that i had an
error in my code somewhere. So I did a CFDUMP of the variables that I'm
inserting into the table and they show the dates the way I want them.
The coldfusion createdate function receives 3 numeric variables that are
/
http://learncf.com
http://flexcf.com
From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf
Of Mike Kear
Sent: Tuesday, 8 June 2010 12:47 PM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Odd date behaviour - CF9/SQLServer2005
@Dale, I would have said that too
@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
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
@googlegroups.com
Subject: Re: [cfaussie] Odd date behaviour - CF9/SQLServer2005
@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
@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.auwrote:
How about CF_SQL_TIMESTAMP instead?
*
*
On 8/06/2010 3:16 PM, Mike Kear wrote:
@Dale, I've
On 8/06/2010 15:16, 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.
Then when i look at the variables in the insert statement, when i use
the CFQUERYPARAM
21 matches
Mail list logo