Code Generators and Dates

Fri, 14 Nov 2008 11:36:00 -0600

I've been working on an application (more about that later) and I've been using Illudium Code Generator to make CFCs for me.

I kept having issues with the Service layer and getting the error message "Bean creation exception in jobsearch.components.correspondenceService". I tried tracking it down, tweaking some configurations to match the other templates that were working. Someone in #coldfusion gave me a good debugging tip - createObject the problem components and do a dump. Once I did so, it was immediately apparent just what the problem is.

I use MySQL, and in two of the tables, I'm using a date field. Here is how Illudium Code Generator sees these fields:



For some reason, MySQL date fields do not get interpreted properly such that nothing is filled in for the type field. So, you must manually edit these fields, and also the CF_SQLTYPE fields.

KnitGal Notions - Illudium Code Generator

Code Generators and Dates