One thing to watch is dates. If you're using datetime columns, you can no longer specify a date like this:
20030709 You have to make it a string, and 14 digits long (to include the time): '20030709000000' The recomended format is 'yyyy/mm/dd hh:mm:ss', which is more readable than the long number. If you specify the former it does not throw an error. It will consider it an invalid date, and convert it to all zeros, which will match all or none of your rows, depending on what the comparison is. This bit me on the rear when I moved to 4.0, although it was simple to fix. --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -----Original Message----- > From: Matt Robertson [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 09, 2003 9:28 AM > To: CF-Talk > Subject: RE: CF5 to MySQL without ODBC > > > >Versoin 3.23.49-nt. Any recommendations for or against moving to MySQL > 4.0? > > That's not the last but one of the later versions. 3.23.53 was the last > one I remember seeing. > > I would absolutely upgrade. > > One thing 4.x has over 3.x is a cache that cranks speed up > significantly. Also 4.x is now production... The thing was beta for > something crazy like a year and a half. > > One thing that disappeared in the move to 4.x is that 3.x occasionally > turned up with corrupted tables. These were easy to fix but the move to > 4 in production (made maybe a year ago?) wiped this issue out forever. > > -------------------------------------------- > Matt Robertson [EMAIL PROTECTED] > MSB Designs, Inc. http://mysecretbase.com > -------------------------------------------- > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
