Thanks Barney. Very useful info. I have never been fully comfortable with mySQL dates but if that's the underlying way to manually construct then my problems are solved. I've been using straight numeric fields in some cases with a yyyymmdd input mask.
Can this be used in SQL queries? i.e. Where datefield between '20020709000000' and 20030709000000' -------------------------------------------- Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com -------------------------------------------- -----Original Message----- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 9:46 AM To: CF-Talk Subject: RE: CF5 to MySQL without ODBC 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
