Query Not Working

Question

The following query keeps aborting in Coldfusion:

	SELECT ID, BusinessName, dba, BusinessPhone, FEIN, CSLB, WCRenewalDate, WCCarrier, CACarrier, CANumber, CARenewalDate, GeneralLiabilityCarrier, HealthInsuranceCarrier, HealthInsuranceRenewal, GeneralLiabilityRenewal
	FROM PProspect
	ORDER BY BusinessName

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.

Any idea why this is happening?

scotwllm · Answer

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.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded