The query runs just fine if I use it within the phpMyadmin mySQL interface, but when I try to use it within a CFQUERY tag, it fails every time. I tried all of the field names within a CFQUERY individually, and they all work except for the HealthInsuranceRenewal and GeneralLiabilityRenewal fields. The other two date fields (WCRenewalDate and CARenewalDate) work just fine. All of the date fields are configured the same way in mySQL -- type = date and default = NULL.
Turns out that I changed the defaults for the HealthInsuranceRenewal and GeneralLiabilityRenewal fields. Some of them had 0000:00:00 in them and some had NULL. I deleted the two columns (luckily I had very little data in them), re-created them, and now it's working fine.