House of Fusion
Search over 2,500 ColdFusion resources here
  
Home of the ColdFusion Community

Mailing Lists
Home /  Groups /  Java

Coldfusion or Java Leap Year Error?

  << Previous Post |  RSS |  Tree View |  Sort Latest First |  Subscribe to this Group Next >> 

Coldfusion or Java Leap Year Error?

I have a CF application that collects data every 5 minutes from a weather Les Schmidt 01/05/2009 04:15 AM
Is this some robot that keeps submitting this question? :-) We've had it Charlie Arehart 01/05/2009 01:20 PM

01/05/2009 04:15 AM
Author: Les Schmidt Short Link: http://www.houseoffusion.com/groups/java/thread.cfm/threadid:1807#5630 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?
01/05/2009 01:20 PM
Author: Charlie Arehart Short Link: http://www.houseoffusion.com/groups/java/thread.cfm/threadid:1807#5631 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 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?
<< Previous Thread Today's Threads Next Thread >>

Search java

December 21, 2014

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
   1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31       

Designer, Developer and mobile workflow conference