Well, if this is a one-time batch transfer then a simple UPDATE abctable SET SomethingDate IS NULL when SomethingDate = '0000-00-00';
should null all the fields in question. Of course, you have to have a NULLable date field. Regards, Mike Hillyer http://www.dynamergy.com/mike -----Original Message----- From: John Thorne [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 3:51 PM To: [EMAIL PROTECTED] Subject: Insert/UpDate dates Working on a routine to export a Filemaker data to mySQL for php application. Using scripts I build a calculated field below: INSERT INTO abctable (JobNumber, JobTitle, AE, Client, StartDate) VALUES (9997, ' ABC ' , 'jrt' ,1234, '') or UPDATE abctable SET JobTitle='ABC',AE='jrt',Client=1234,SomethingDate='' WHERE JobNumber = 9997 and send this to mySQl via ODBC Problem. When the Filemaker date is blank the calculated field is produces SomethingDate=''. After the Insert or update the mySQL field is 0000-00-00. And in the php form shows up as 00/00/0000. How can I get the date to be blank in mySQL. thanks jrt --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php