Coldfusion or Java Leap Year Error?

[Les Schmidt]

I have a CF application that collects data every 5 minutes from a weather station and many other devices at my home.  At about 4pm PST today (2/29), or midnight GMT on 3/1 , and for all of the 5 minute intervals thereafter, the web page that displays  data for today vs. the same time yesterday stopped working.  The error was:

Query Of Queries runtime error. Comparison exception while executing =.
Query Of Queries runtime error.
Type cast exception: Failed to cast object of type java.lang.String to java.util.Date.

The specific query is looking for a recorddate (formatted as 'm/d H:m') is:
<cfquery dbtype="query" name="yesterdayData">
        SELECT RecordDate,RecordTime,Rain24HR
  FROM masterData
  WHERE '#yRecordDate#'= recordDate
</cfquery>

If somehow GMT is at play (and I don't understand how or why, because now() correctly reports local time), then the WHERE clause would have been looking for a recordDate of '2/29 16:00' when it stopped working.

I've searched all over and found a reference to a CF error.
http://www.flatpackedworld.co.uk/blog/index.cfm/2008/2/28/Coldfusion-possible-Leap-Year-bug

Because the query has worked continuously every 5 minutes for > 3 years, I'm suspecting that leap year is having a hand in causing this error.  Any suggestions?  possible solutions?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/java/message.cfm/messageid:5630
Subscription: http://www.houseoffusion.com/groups/java/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.40

[Charlie Arehart-2]

Is this some robot that keeps submitting this question? :-) We've had it
today, and twice on 12/28
(http://www.houseoffusion.com/groups/java/message.cfm/messageid:5626 and
http://www.houseoffusion.com/groups/java/message.cfm/messageid:5622).  Paul
quipped about the 2nd one, too, at the time.

Les, an answer was offered
(http://www.houseoffusion.com/groups/java/message.cfm/messageid:5624). Any
thoughts on that? Are you repeating the question because you missed that? Or
just that you didn't find it responsive? Help us help you. :-)

/charlie


-----Original Message-----
From: Les Schmidt [mailto:les242non@...]
Sent: Sunday, January 04, 2009 6:20 PM
To: java
Subject: Coldfusion or Java Leap Year Error?

I have a CF application that collects data every 5 minutes from a weather
station and many other devices at my home.  At about 4pm PST today (2/29),
or midnight GMT on 3/1 , and for all of the 5 minute intervals thereafter,
the web page that displays  data for today vs. the same time yesterday
stopped working.  The error was:

Query Of Queries runtime error. Comparison exception while executing =.
Query Of Queries runtime error.
Type cast exception: Failed to cast object of type java.lang.String to
java.util.Date.

The specific query is looking for a recorddate (formatted as 'm/d H:m') is:
<cfquery dbtype="query" name="yesterdayData">
        SELECT RecordDate,RecordTime,Rain24HR
  FROM masterData
  WHERE '#yRecordDate#'= recordDate
</cfquery>

If somehow GMT is at play (and I don't understand how or why, because now()
correctly reports local time), then the WHERE clause would have been looking
for a recordDate of '2/29 16:00' when it stopped working.

I've searched all over and found a reference to a CF error.
http://www.flatpackedworld.co.uk/blog/index.cfm/2008/2/28/Coldfusion-possibl
e-Leap-Year-bug

Because the query has worked continuously every 5 minutes for > 3 years, I'm
suspecting that leap year is having a hand in causing this error.  Any
suggestions?  possible solutions?



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/java/message.cfm/messageid:5631
Subscription: http://www.houseoffusion.com/groups/java/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.40