Nevermind. Stupid mistake. I was looping over a number of records and it turns
out that one of the records had a null value set which was what caused the
error. Had nothing to do with MySQL dates at all. Ugh.
> I have an app that I have created using CF 9.01, MySQL 5.1.41 and ORM.
> One of the properties of my object is a start date. Everything inserts
> and updates to the MySQL database without a problem. This issue that I
> am having is when I try to perform any CF date functions on the stored
> date.
>
> If I try to do a datecompare or datediff function on the start date, I
> get a "Date value passed to date function DateCompare is unspecified
> or invalid" error message. However, if I try either isValid("date",
> Deal.getStartDate()) or isDate(Deal.getStartDate()), both return true.
> Any thoughts?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349601
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
