I use MySQL. I love MySQL. According to a great deal of feedback I've received re: Meld Forums being MySQL only, I seem to be in the minority (at least in the former). So, in making Meld Forums MS SQL-friendly, I made the startling, depressing discovery that MS SQL *doesn't* *have* *LIMIT* functionality. You can use TOP to get the first X rows of a query, but you cannot specify a start position.
When ColdFusion connects to MySQL 4/5 databases, the default choice is to use JDBC. This is all well and fine, but a difference-of-opinion between JDBC Dates and MySQL dates can cause your application fits. The issue is created when you use an empty string(not a NULL, which is a different bird all together) to update a date field. MySQL interprets this as '0000-00-00 00:00:00' and stores that value. JDBC by design does not recognize'0000-00-00 00:00:00' as a valid date and returns an error.
The most common solutions suggested for dealing this are either a work-around or not easily applied. A little experimentation revealed an ideal solution to this problem.
Recent Comments