http://www.knitgal.com/blog/index.cfm KnitGal's notions about everything and nothing in particular. en-us Sat, 04 Sep 2010 16:38:16 -0600 Fri, 14 Nov 2008 11:36:00 -0600 BlogCFC http://blogs.law.harvard.edu/tech/rss lola@his.com lola@his.com lola@his.com no http://www.knitgal.com/blog/index.cfm/2008/11/14/Code-Generators-and-Dates I've been working on an application (more about that later) and I've been using <a target="_blank" href="http://cfcgenerator.riaforge.org/">Illudium Code Generator</a> to make CFCs for me. <br /><br />I kept having issues with the Service layer and getting the error message "Bean creation exception in jobsearch.components.correspondenceService".&nbsp; I tried tracking it down, tweaking some configurations to match the other templates that were working.&nbsp; Someone in #coldfusion gave me a good debugging tip - createObject the problem components and do a dump.&nbsp; Once I did so, it was immediately apparent just what the problem is.&nbsp; <br /><br />I use MySQL, and in two of the tables, I'm using a date field.&nbsp; Here is how Illudium Code Generator sees these fields:<br /><br /><code><cfargument name="responsedate" type="" required="false" /&gt;</code><br /><br />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.<br /> MySQL Illudium Code Generator Fri, 14 Nov 2008 11:36:00 -0600 http://www.knitgal.com/blog/index.cfm/2008/11/14/Code-Generators-and-Dates http://www.knitgal.com/blog/index.cfm/2008/6/20/Aliasing-MySQL-Startup <p>I've got MySQL installed, via binary download from <a href=""http://www.mysql.com"" target=""_blank"">MySQL.com</a>, on my Leopard setup. Much of the time I access my databases through Terminal. It's really easy to set up an alias in your bash .profile so that all you need to do is type one word to start up MySQL, then type your password. Here's how I've set up my alias:</p><code>alias startmysql=""mysql -u name_of_user -p""</code><p>Note that ""name_of_user"" should be replaced with the name of the account that you use to access MySQL. You shouldn't be using root, in any case, even on your personal laptop.</p> MySQL Fri, 20 Jun 2008 05:53:00 -0600 http://www.knitgal.com/blog/index.cfm/2008/6/20/Aliasing-MySQL-Startup