Thoughts from the mountains

I ran into a issue today due to a difference between MySql 4.1 and 5.1, or at least that is what I'm currently thinking. We have a ColdFusion template that is running as a scheduled task to determine new and updated records in a table on one server and then either updates or creates new records on a second server at a different location. Pretty straight forward, and it has worked well for the last several years.

Today I experienced the following error, "Unable to Load Library Null" from a custom tag that was in use on a site that I was moving from CF7 to CF9. The custom tag, CFX_Check_Email, was working fine on my CF7 server, but was producing errors on my new CF9 server running IIS 7.5 and Windows Server 2008. The custom tag did run fine on my development machine with Windows XP and CF9, so I was a little confused as to why I was getting the error on my new server.

I'm currently moving a site from MySQL 4 and ColdFusion 7 on IIS 6 to MySQL 5 and ColdFusion 9 on IIS 7. One of the first problems that I noticed was the following error on one of my database driven templates:

Cannot convert value ‘0000-00-00 00:00:00? from column X to TIMESTAMP.

When I went to upload photos to my photography website this afternoon I noticed that the FCKEditor that I use in my site was no longer displaying but instead a basic textarea was shown. For those not familiar with FCKEditor it is a rich text editor plugin that allows for a WYSIWYG html editor in websites. As I just installed Firefox 3.6 the day before, I determined that there must be some type of conflict so I headed off to google to see what the deal was.

How to use jquery and coldfusion to bind a select box to another select box without using the supplied bind attribute of the cfselect tag.